Solid and reliable
February 12, 2016

Solid and reliable

Anonymous | TrustRadius Reviewer
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.

Pros

  • 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.

Cons

  • 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.

SolarWinds SQL Sentry Feature Ratings

Performance dashboard
8
Intelligent alerting
6
Top SQL
9
Historical trend data
8
Virtualization support
5

Comments

  • Rick Pittser | TrustRadius Reviewer
    Hello, We greatly appreciate your detailed rating of SQL Sentry software. Our Development team has been hard at work developing and implementing large feature sets over the last 18+ months. We have added improved baselines and cloud functionality, support for APS, Azure SQL DW, VMware and Azure SQL DB. We are working to enhance our Top SQL functionality, as well as updating our UI/UX to continue making SQL Sentry as helpful and efficient as possible for you and the rest of our customers. If you are having client performance issues, please be sure to run them by our dedicated support team at support@sqlsentry.com. We have customers with hundreds of monitored instances, who experience optimal performance from SQL Sentry. However, each environment is unique, and yours may require some additional configuration to improve performance. Again, thank you for your thoughts. Our customers are our best resource for finding ways to improve our products. Rick

More Reviews of SolarWinds SQL Sentry