Solid and reliable
February 12, 2016
Solid and reliable
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with SQL Sentry Performance Advisor
I work for a service provider, where we provide SQL Server consultancy and managed services to our customers. Within the managed services team, we monitor and support our customers with SQL Sentry.
Predominantly, SQL Sentry is used to analyse and diagnose historical performance issues as well as on-going performance issues across 60 or so SQL Server instance.
Predominantly, SQL Sentry is used to analyse and diagnose historical performance issues as well as on-going performance issues across 60 or so SQL Server instance.
- SQL Sentry is very effective at narrowing down a global server performance issue to a single statement or a handful of statements. It does this by helping identify what T-SQL statements were running at a given point in time.
- It is very good at identifying blocking issues through the use of the Blocking SQL analyzer
- It is very good at helping to identify what impact executing code is having on CPU, memory, disks. It does this with a combination of top sql and global server performance metrics.
- It's difficult to use SQL Sentry to compare what T-SQL was executing between two different time periods. For example, it would be good to have a view that showed me what T-SQL statements ran between 08:50 and 08:59 and to be able to compare this with a similar view corresponding to 09:00 and 09:09.
- The SQL Sentry repository database doesn't seem to operate at scale and suffers from performance problems when monitoring as many as 50 SQL Server instances. On occasions, it can sometimes take several minutes to switch tabs or to load up a screen.
- confio and spotlight
No competition - SQL Sentry wins hands down every time for the level of detail that it provides.