SQL Sentry helps me do my job!
February 25, 2016
SQL Sentry helps me do my job!
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with SQL Sentry Performance Advisor
SQL Sentry Performance Advisor is being used to monitor our important SQL Server Production servers. I use it when I need to find out what is causing an outage of an application and to find out what SQL is possibly causing slower performance. I also use it to find times when the load is greater on resources, for example, on the CPU. I find it to be a very valuable tool in gaining visibility into my servers.
- Graphs showing load on resources in both SQL and Windows.
- Showing detail when a deadlock occurs so that it's obvious what SQL is running that has caused the killing of a victim process.
- Retaining historical data so that an issue can be researched thoroughly.
- Sometimes the graphs are a curve and sometimes they are blocks - I'm not sure why - I'd probably prefer to always see curves.
- When looking at blocking, I would prefer ordering to be of the longest running process descending to the shortest running process.
- I find it a little difficult to understand the results of the Top SQL. I'm not sure how it could be clearer and cleaner but there may be some room for improvement there.
I like both products. But, SQL Sentry seems to give a more in-depth look into the processes that are running at any given time and how they may be effecting performance.