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.
- Idera SQL Diagnostic Manager and Redgate SQL Monitor
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.