SQL Sentry is a great product that makes my life much easier.
Tim Hermann | TrustRadius Reviewer
Updated May 01, 2020

SQL Sentry is a great product that makes my life much easier.

Score 10 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with SQL Sentry

We are using it to monitor our SQL Server instance with customer data on it. It enables me to review the load on our server and also monitor high cost SQL Statements.
  • Capture costly SQL Statements
  • Alert the Database Administration Staff to deadlocks, blocking and other important issues
  • Able to provide management with performance statistics on the database and server
  • Some issues monitored to generate a health score I find to be misleading. One example would be % of free space when you have the data files set for autogrowth.
  • The Deadlock monitoring alerted us to an issue with the code and implement a fix.
  • The Top SQL section allowed me to optimize some code that was causing performance issues for one of our customers.
One of our customers was suffering from performance issues on a job that ran at the top of every hour. I was able to modify the code in the job to reduce the run time by over 90%.
None, I've used SQL Sentry at another job in the past and recommended it to be used at my current job.
I believe SQL Sentry is well suited for any environment where you need to monitor performance for both the databases and the database server. I wouldn't think it would be neccessary in a development environment.

SQL Sentry Feature Ratings

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

Using SQL Sentry

1 - I use it as the database administrator
  • Provide automated alerts for many conditions
  • To help find the most costly SQL Server statements
  • Provide ability to track disk peformance
  • Provide trending use of disk space
  • I can't say we are doing anything innovative, the basic features are rich and I'm sure I'm missing some interesting base functions.
  • We are getting ready to set up Availability Groups, this will allow me to monitor them much better than SQL Servers standard functionality
  • Better customer service as it alerts me automatically to loss of service issues so I can react and either get things fixed before it impacts the customers or to let my management know as soon as possible
  • It helps me find expensive SQL so our customers get better performance and we make better use of our resources
This has already become an essential monitoring tool for our SaaS environment.

Evaluating SQL Sentry and Competitors

  • Product Features
  • Product Usability
  • Prior Experience with the Product
Prior experience was the most important, I knew how good the product was and the value it provides.
I might have looked to other products such as Quest Softwares SQL Server monitoring products.

SQL Sentry Implementation

Implementation was quite easy, SQL Sentry also provided a dedicated support person to help me out and follow up shortly after the initial implementation.
Change management was minimal
  • Setting up notifications of particular SQL Server and Windows Host events.

SQL Sentry Support

I have always received prompt, professional support. Without fail, they are able to answer my questions and get things up and going.
ProsCons
Quick Resolution
Good followup
Knowledgeable team
Problems get solved
Kept well informed
No escalation required
Immediate help available
Support understands my problem
Support cares about my success
Quick Initial Response
None
The support staff provided me excellent support when I had to start supporting SQL Server instances on a different domain. The online documentation was incorrect, so the support team was able to find a solution for me that resolved my problem.

Using SQL Sentry

Once you get over the inital hump, SQL Sentry is very easy to use, but also has a great deal of information that is very configurable.
ProsCons
Like to use
Relatively simple
Easy to use
Technical support not required
Well integrated
Consistent
Quick to learn
Convenient
Feel confident using
None
  • Setting up a new SQL Server Instance to monitor
  • Updating the license key
  • Modifying the metrics used to alert me
  • Sometimes it gets a bit confusing on how to separate global versus local conditions and settings