SQL Sentry - A magic wand of the quest for how to become a more peaceful DBA or just another life jacket
February 18, 2016

SQL Sentry - A magic wand of the quest for how to become a more peaceful DBA or just another life jacket

Vasilis Papamichael | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with SQL Sentry Performance Advisor

We're using it (ICT department) as a central information point for company wide production SQL infrastructures. It quickly help us to pinpoint issues related to blocking, deadlocks, poor performing SQL queries and the subsystem (server components) as well.
  • As a software, it is synonymous to "1 picture is worth a 1000 words". It has the ability to give you at a glance all the necessary information related to databases, instances, networking and server, both in live and historical views
  • From a visualized approach it is very well designed. The row of information is structured in a such way that an experienced DBA can quickly pinpoint any SQL or platform issue or analyze the trends as well.
  • It offers a customization level which can be combined with numerous automation tasks covering any need beyond the basic monitor-alert-analyze-remedy.
  • From every aspect, SQL Sentry is an excellent choice in terms of ROI.
  • It would be nice if the program could offer a solution to remedy problems related to poor query performance i.e. to suggest the addition or removal of an index.
  • By extracting the information presented live for our ERP database and implementing this information as a lab environment we came to a conclusion that we could positively affect the servers iOPS.
  • In another case we found that we had to increase the number of temp DB files.
SQL Server hosts many production databases. It was suffering on a daily basis for a couple of hours because that was the time where numerous batch requests were stacking. We found quickly that it caused by memory bottleneck . We only had to increase the overall server memory and SQL min/max memory as well.
Sentry is more centralized and wide open. It has abilities to "dive" into deepest SQL aspects providing details that other products are just unable to do. It is not just a quick monitoring, alerting tool. It has the unique ability to "teach" or "remind" you (throughout policies and automation) solutions that were difficult to recall under pressure.

SolarWinds SQL Sentry Feature Ratings

Performance dashboard
10
Intelligent alerting
10
Top SQL
10
Historical trend data
10