SQL Sentry Business Use Case
Updated August 01, 2016

SQL Sentry Business Use Case

Charles Hitchcock | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with SQL Sentry Performance Advisor

We use SQL Sentry Performance Advisor for real time monitoring of our production systems. It has been extremely useful at providing an at-a-glance summary of current and historical activity. Additionally, the report feature has been invaluable to us for monitoring metrics over time. Performance Advisor has been instrumental in identifying non-SQL related waits that are impacting SQL performance.
  • Dashboard tick
  • Reports
  • Blocking and Deadlocks
  • Make interface less complex
  • Use simple terminology for menu items
  • Idera, Solarwinds, Apex and Nagios
SQL Sentry has a dashboard and tools that better suit our needs as a business. The tab based layout we found was easier to use and for the layman to understand. The top SQL feature has been invaluable to us for locating problems in real time.
SQL Sentry Performance Advisor is well suited for evaluating waits and helps our organization make decisions on scheduling and helps with tuning poorly performing jobs and queries.

SolarWinds SQL Sentry Feature Ratings

Performance dashboard
10
Intelligent alerting
9
Top SQL
9
Historical trend data
10
Virtualization support
10

Using SQL Sentry Performance Advisor

12 - Support Engineers, Database Admins, Developers, Management.
4 - Database and System Admins. Devops.
  • Alerting
  • Real time monitoring
  • Historical reporting
  • Integration with other systems (SSRS, etc)
  • Running open queries via linked servers on SSMS to gather data from Linux based systems.
  • Conditional based alerts.
  • Integrated reporting with Tableau via SSRS.
  • Set baselines.
  • Setup more Windows based alerts.
  • SQL Sentry has had a positive impact in that root cause analysis can be performed much faster. This has led to reduced time spent investigating.
  • The complexity of SQL Sentry can be overwhelming when training new users/admins.
We give it this rating because of the flexibility of this product and the ability to tailor it to our needs.