SQL Sentry Performance Advisor - a great monitoring tool for SQL Server
Overall Satisfaction with SQL Sentry Performance Advisor
Sql Sentry Performance Advisor is a great tool, whether it's looking at the meaningful dashboards or receiving the custom alerts. Being busier nowadays, I rely more on responding to the email alerts such as poorly performing sql jobs.
It is a mainstream product with features extended to cloud reporting/dashboard, therefore catering to a wider audience such as executives or IT managers
We currently only use Performance Advisor for production SQL systems. To further troubleshooting, there have been times requiring the need of SQL Profiler, SQL Sentry's Event Manager, Fragmentation Manager, etc...My wishlist is for it to be an all-encompassing product, to actually give recommendations on making the system better, if faster disks could make a difference, if a missing index was the issue, etc...
All-in-all, I'm satisfied with SQL Sentry Performance Advisor. It makes my job easier with less fire fighting.
- Custom alerting: can set different thresholds and different email recipients
- Quite scaleable, and speed of the console is not degraded as more systems are monitored; database repository is fairly small for a one month retention of approx. 10 servers. For us it's 1 GB per server. can fluctuate based on your own settings
- Custom responses to job thresholds and error return values
- It would be ge great to see more of a "Doctor" or "Advisor" in that the application would give recommendations. You would generally need a good grasp of what could be the problem and what could be the fix-up
- Include more functionality into Performance Advisor without having to purchase different modules