In the Daily SQL war zone with a trusted partner: SQL Sentry
February 17, 2016

In the Daily SQL war zone with a trusted partner: SQL Sentry

terry anthony | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with SQL Sentry Performance Advisor

SQL Sentry Performance Advisor is being used to identify and optimize user created stored procedures, views and functions that perform inefficiently so they can be optimized to run at peak efficiency. It is used to alert the IT and operations staff of events that are causing the SQL server instance to become unstable and go offline or restart.
  • Monitors long running queries and alerts on them.
  • Provides context for the poorly performing query such as the user running the query, start and end times, number of reads and writes the query or queries has performed.
  • Reporting on SQL server top poorly performing queries and provides context to be able to determine why the queries are having such poor performance.
  • Provide an interface to perform ad-hoc queries of the data in the SQL Sentry database or a way to export the data for more detailed analysis.
  • More detail in the online and local help. More examples that address 'real world' issues.
The former company I worked for had such an extremely large and high volume transaction volume. Idera's SQL Diagnostic Manager just could not keep up with the pace of the transactions. The main SQL server cluster was running between 25,000 to 50,000 transactions per second (24 hours a day) with between 25,000 and 32,000 simultaneous user connections. SQL Sentry was the only Windows and SQL sever monitoring tool that could actually keep pace with the daily processes.
Monitoring real time Windows server health metrics and SQL server metrics presented in a graphical interface that makes issues imminently apparent is where SQL Sentry Performance advisor excels. It allows a very quick response to current server conditions (both Windows and SQL server) when issues occur. Disk space analysis is less helpful, especially with virtual servers.

SolarWinds SQL Sentry Feature Ratings

Performance dashboard
Intelligent alerting
Historical trend data