Winning With SQL Sentry Performance Advisor
April 29, 2016

Winning With SQL Sentry Performance Advisor

Matthew Bixler | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with SQL Sentry Performance Advisor

We utilize Performance Advisor to gather performance metrics and to monitor SQL Server thresholds. It is a quick way to access bottlenecks when issues are raised. We then drill down into the suspected areas and find the root cause.

Pros

  • Gather and report on metrics
  • Amazing breadth of information
  • Customizable

Cons

  • Can be sluggish at times
  • Setting up connections to servers is difficult to troubleshoot
I recommend SQL Sentry for critical SQL Servers and not all. This will control costs and maximize value. However, I would recommend it if you have SQL Sentry to utilize it in a QA/Test environment for actively developed non-trivial applications to help diagnose problems before they move to production.

SolarWinds SQL Sentry Feature Ratings

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

Comments

  • Rachel Siragusa | TrustRadius Reviewer
    Hello Matthew, Thank you for reviewing and rating SQL Sentry. We are so happy to know that SQL Sentry has been helpful in identifying performance issues. In regards to occasional sluggishness, make sure to verify that you are performing regular maintenance on the SQL Sentry database. If you already are, make sure the current plan is still adequate, as the frequency of maintenance may need to increase as the size of the SQL Sentry database grows and the number of monitored connections increases. Fragmentation and poor statistics can certainly begin to cause problems, especially for heavily utilized indexes such as those related to the Dashboard and Top SQL. If you have any continued issues or questions, please don’t hesitate to contact our support team (support@sqlsentry.com)

More Reviews of SolarWinds SQL Sentry