First impressions of SQL Sentry Performance Advisor
April 29, 2016

First impressions of SQL Sentry Performance Advisor

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

Overall Satisfaction with SQL Sentry Performance Advisor

SQL Sentry Performance Advisor is being used for monitoring production and staging SQL Servers. The main tabs used are Top SQL, Blocking, and Deadlocks. Fragmentation Manager is primary used to monitor fragmentation percentage. We do not use it at this time to actually defrag the indexes. Plan Explorer is my primary tool for query plan review and optimization.
  • Quickly drill down from Top SQL to query plan and dashboard to evaluate performance and bottlenecks.
  • Demonstrated for me that several of the SQL Servers were over allocated in resources. I used it to tune the right amount of cores and memory.
  • Alerts, alerts, and more alerts. A level of notification and communication I would not have without the tool.
  • It has a lot functionality, the learning curve is pretty large. I would like to see more videos with more detail.
Much more organized and easier to use than Profiler and Activity Monitor. Job failure monitoring is critical.
I still use Activity Monitor and Profiler because I have not found the exact replacement in SQL Sentry Performance Advisor yet.

SolarWinds SQL Sentry Feature Ratings

Performance dashboard
Intelligent alerting
Historical trend data
Virtualization support
Not Rated