Where can I find the SQLTreeo log files?

SQLTreeo Add-in generates log files for troubleshooting in case an issue/error arises.

The location of the log files are as following:

C:\Users\[YourUserAccount]\AppData\Local\SQLTreeo\install.log
And
C:\Users\[YourUserAccount]\AppData\Local\SQLTreeo\SQLTreeo\Logs\sqltreeo_dll.log

 

Can I add Compare to an existing ADDIN license later on?

Yes!

Do you have any volume pricing packages?

Yes, we offer volume pricing packages. Please note that any volume pricing is single-purchase-based; previously purchased or planned purchases of licenses are not considered.

Steps

  1. Please send your request with details of requested volume to sales@sqltreeo.com for more information.

Can I get an invoice with our PO number?

Yes, you can!

We are in the process of automating this. At this moment, however we ask you to follow this procedure:

Steps

  1. Purchase your licenses
  2. After purchasing, send your request for an invoice, with required details which are required according to your invoice acceptance criteria), like Name, Organization, Address, Valuta, PO number, etcetera to servicedesk@sqltreeo.com. You will receive an invoice (PDF) within 24 hours by -email.

Can you send an offer? I need this to get a PO-number!

Sure!

We will be happy to do so!

Steps

  1. Send your request for an offer, with details which are required according to your PO criteria, like Name, Organization, Address, Valuta, etcetera to sales@sqltreeo.com.
  2. You will receive an offer (PDF) within 24 hours by -email.

I bought an unlimited (lifetime) license in 2013 but I cannot see this license in the license overview / purchase history. How can I get back my license and use it with the latest version?

Your MySQLTreeo section show your purchases and license overview. If your license key is not listed, it is probably because have used a different account/e-mail addres when purchasing the license.

Steps

1 – Check your purchase details against your registration details

2 – Login with your correct details, if applicable

3 – If it is still not possible to login, please contact our servicedesk at servicedesk@sqltreeo.com. They will help you.

Do I have to buy new licenses to update SQLTreeo ADDIN?

If you have purchased a lifetime license any update of SQLTreeo ADDIN is free of charge.

Where can I download the latest version of SQLTreeo Addin?

To download the latest version:

Steps

 

1 – Go to https://www1.sqltreeo.com/sqltreeo-ssms-add-in

2 – Click on “pricing Plans” or scroll down

3 – Click on “Download”

 

Permissions

None, but you need to be registered.

Can I assign users with specific rights?

SQLTreeo monitoring allows Administrators to assign roles and corresponding rights to users or usergroups. There is no limit to the amount of users assigned.

Steps

  1. Login to your Monitoring environment. You see the Dashboard of your environment
  2. Click on the left on “Configuration”
  3. Click on “Users” (on the left bottom).
    1. Here you see all assigned users to your environment
    2. To change the rights per user, click on the grey button on the right. You can chose Edit, Disable, Remove, impersonate)
    3. Select “Edit” to adjust user rights
    4. Follow step 6
  4. Click on “Add user”
  5. Fill in user details
  6. Select usergroup. Usergroups are predefined rights on actions.
    • If you want to create your own usergroup click on the Arrow next to “Users”
    • Select “user groups”
    • Select “Add user group”
    • Complete the fields
    • Click “Save”
    • Click on “Access Rights”
      • Now you can choose which rights are alligned with specific actions
  7. Click “Save”.

Permissions

You must be Administrator.

Other Sources

There is a short video: “How to assign rights to users”

Here are some screenshots.

 

Where can we download the ADDIN manual, to set up dynamic folders?

The dynamic folders functionality is integrated in SSMS ADDIN, and available for everyone using SSMS 2012 or higher and is running on SQLTreeo V0.8.4 or higher.

There is no documentation on dynamic folders.

 

What is SQLTreeo Monitoring Software?

SQLTreeo Monitoring is a cloud based software solution provided as SaaS; what you see is what you get. No long installations and configurations, all you need to do is to install an agent in your environment and add your SQL servers, that’s it.

With SQLTreeo Momitoring you have instant access to all relevant information to keep your MSSQL server healthy and with maximum performance. It is designed for DBAs, by DBAs! Drillling into details of job or backup histries simplifies your time spent searching for answers! Why not try it yourself for 14 days?

 

Watch the YouTube video here!

What is the added value of SQLTreeo Monitoring against SSMS?

Your MSSQL database has all information available for you to optimize performance and solve incidents. However, SSMS is simply too limited to show that information and the way to retrieve the information you need via SSMS is time consuming and can lead to several manual interactions to get information. (Reading error logs, checking the job activity monitor to see if your jobs have failed or succeeded, writing long scripts or check db for db if your backups have completed successfully, etc).

Via SQLTreeo Monitoring you see all the important information you need on a daily basis. No need for manual interactions anymore, just open the dashboards and you will have the information you want to see within seconds. All this information is displayed in an intuitive way, using hovering and drill-down techniques, and the use of colors and icons in dashboards.

Does SQLTreeo Monitoring store data?

SQLTreeo Monitoring does not store any company-sensitive or user-related data. The agent “only“ executes a number of queries at given intervals in your environment, and polling your server every few seconds to see if there has been any changes since the last poll. The information being retrieved from system tables will be sent to your browser(interface). Sensitive data is neither stored nor replicated or sent. All the data is only accessible within your environment.

So, in one sentence: SQLTreeo enables you to access all your SQL Server information you need to discover bottlenecks, create awareness for server health, and be notified in case something goes wrong.

Does SQLTreeo Monitoring take care of backups?

SQLTreeo Monitoring does not backup; that is your responsibility.

What SQLTreeo does show are the history and status of backups per server. It also allows you to drill down into detailed data about the backup based on time intervals you select. This provides insight of that status of any backup.

Which types of Dashboards does SQLTreeo Monitoring provide?

SQLTreeo has several types of dashboards which are specific in its purpose. The dashboards are topic related.

  • Server dashboard, which show the status of your server. In case something is wrong it will be displayed as such (green/orange/red) and it will give you the indication for why your server is in that state.
  • Jobs dashboards provide all the information you need for checking history execution, run times, status, disabled, retrying and such.
  • Backups dashboards gives insight in server backups per database. It shows – in a very short time – the status of your backup plans, failed, outdated backups, logs not created, and you can easily filter out the root cause of failures and create backups to fix it.
  • Alerting dashboards
  • Reporting dashboards
  • Replication dashboards

 

What about Alerts in SQLTreeo Monitoring?

Alerts are setup as default but with the many thresholds provided you simply click and select the required alerts and thresholds you need to monitor your MS SQL Server.
Thresholds are created to help you monitor your environment. Each DBA knows there are a few things that need to be taken care of: Make sure backups are made, disks have enough free space, no blocking queries, or long running transactions, log usage of your database, jobs that failed etc.

Thresholds can be configured with conditions. SQLTreeo has created many thresholds which are close to what a DBA daily monitor. And you have SQL Server performance counters to specify certain areas of your server for monitoring. Values indicate on which value a condition is triggered. For example disks are triggered CRITICAL when >90% utilization, send a warning. When 90%<’status’>50% and only if it’s that state for more than X minutes, send a warning.  Once the disk is below 50% , send a message: status = ‘clear’)

Once a threshold Is triggered it will be shown in your dashboard, beeps a notification on your interface and sends an e-mail to the users that have subscribed to that servergroup/environment/usergroup/action. When clicking on the red icon you immediately see the reason and you can take actions. This saves you a lot of time, instead of getting a call from someone saying the disks are full and you have to figure out which server, which disk, what is the root cause (error log ), go to server and remove unneeded files or such. This takes up a lot of time, with SQLTreeo monitoring it will take only seconds, avoiding this call you otherwise would have received. Because now you know when an issue is going to occur.

What do I need to install to work with SQLTreeo Monitoring?

SQLTreeo Monitoring is a cloud based monitoring solution which implies no programming. The only thing you need to do is download and install SQLTreeo Agent which acts as broker between SQL server and our software.

Here is the YouTube Video how to do it!

 

What limitations are there for SQLTreeo Monitoring users?

SQLTreeo monitoring supports an unlimited number of users. You, the SQLTreeo Monitoring administrator can assign roles to users and invite them to look to the live monitoring of a specific database. You can consult a colleague, for example for a second opinion or comments.
The integrated chat function allows you to have instant communication without being in the same location.
You can assign users with specific permissions on what actions they can do (show, add, delete, modify) on all the screens in your interface; if you don’t want testers to make changes on production environment or give them any insight you can only show them what they need to see.

Want to know how to add users and assign roles in SQLTreeo Monitoring? Watch the video here.

 

Which security standards does SQLTreeo Monitoring apply?

SQLTreeo monitoring security standards are documented here.

Why did you develop your own monitoring software platform?

 

Why is SQLTreeo Monitoring licensing so attractively priced?

The short answer is: we are not greedy!

We really think that cloud based database monitoring licensing is the opposite of “old school” on-premise licensing.

  • Our software license model is based on the number of your MSSQL instances;
  • Our base module is extremely features-rich;
  • Our additional two models are for specific use and are fixed priced;
  • Our support is 365 days a year and free of charge;
  • Our license model is based on instant purchase; no contracts or investments required.

Contact sales@sqltreeo.com if you require more information.