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.
SolarWinds SQL Sentry Feature Ratings
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.