SQL Sentry Performance Advisor - a great monitoring tool for SQL Server
February 12, 2016

SQL Sentry Performance Advisor - a great monitoring tool for SQL Server

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

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
SQL Sentry Performance seemed to be more scaleable than others, and flexible enough for pricing because it was module based if you wanted others like Event Manager, SSAS Advisor, etc...

To have all your SQL instances monitored can be rather expensive. So, in my opinion, it's ideal to buy PA for only your really critical SQL servers.

SolarWinds SQL Sentry Feature Ratings

Performance dashboard
Intelligent alerting
Historical trend data
Virtualization support