I like SQL Sentry
May 14, 2016
I like SQL Sentry
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with SQL Sentry Performance Advisor
I am using it to monitor 5 servers running Microsoft SQL Server 2008R2, soon to be upgrading to a newer version. We have replications and many jobs including SSIS jobs that we need to maximize performance and address failures quickly in a production environment [that is] busy 365 days a year. I find that its primary benefit for me so far is in identifying job failures (notification) and identifying performance problems and giving some information that helps resolve them.
- It identifies deadlocks and long running queries and shows exactly how the problems are occurring.
- It shows performance of your server in real time, especially the metrics that actually tell you useful things.
- It lets you change the monitoring to another server without a terrible hassle when this is desired.
- Some link to what each metric is telling you and how you may use it to judge performance or use it to improve performance would be very nice. A number of the folks who use this product, and me, were not computer science majors or or professional server managers. Managing and monitoring servers is an ancillary duty that just got added on.