SentryOne Brief Review
November 28, 2017
SentryOne Brief Review
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with SQL Sentry
We have been using SQL Sentry exclusively in our database department. Occasionally our technical leads join our analysis and troubleshooting sessions. We run screen shares in those sessions to solve application performance related issues. We have used SQL Sentry analyzing and researching long running SQL queries and deadlock issues, which have become major bottlenecks in our application development processes. The software has helped us address missing index issues and optimize query performances. In the past, we were also able to make a few important design decisions based on the analysis and statistics that were provided by SQL Sentry monitoring service. Decisions that include when and where to use application or database caching mechanism, as well as the benefit of implementing ad-hoc queries versus stored procedures. It has also helped our QA department to identify most key issues in our load tests.
- Top running SQL - gives statistical information about long running queries as well the ability to customize filters.
- Deadlock - provides detailed graphical analysis on deadlock chains and involving parties. It is very intuitive and easy to pin point the cause of deadlocks.
- Baseline tuning - provides both sampling and historical trending information on SQL servers as well as detailed statistical information about resources utilization.
- Calendar of events - a centralized place for reviewing SQL agent jobs.
- Condition list - set of conditions that can be customized for business requirements.
- It would be nice if the reports can be interactive like drill down, clickable content, etc.
- Navigation could improve and become more intuitive.
- Calendar of events could also improve - wish the date and time range could be specified instead of just by day or interval.
SQL Sentry offers more features and is customize-able to fit our business needs. It has more centralized management and support. The company's technical support is also top notch. It is also worth mentioning that SentryOne Team Blog is an excellent source. One can find lots of valuable troubleshooting skills on the blog site - very educational and informational.