Sql Sentry, a power tool for DBAs
Updated May 23, 2020
Sql Sentry, a power tool for DBAs
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with SQL Sentry
We use SQL Sentry Performance Advisor on both MSSQL Server and Analysis Services. It allows us to go back and investigate performance events that occurred outside of the normal workday and correlate what was happening on a server to other servers that it was connected to at the time. Over time it has allowed us to address specific recurring performance problems that we might not have been able to easily track down.
- PA focuses attention to problem areas when in the moment and helps get us to quicker problem resolution. Trapping execution plans for long running queries has been particularly helpful as has the insight into disk activity.
- Running PA in both QA and production has allowed for more efficient benchmarking of changes due to go to production and resolution of possible performance problems.
- PA does not replace a DBA but it does help them to be more focused and efficient in a number of situations.
- I would like to see the UI be more responsive, particularly when looking at historical records.
- Capture of execution plans is sometimes unpredictable and I would like to see that more often
- Reporting of job runtimes over history is difficult. Pulling baselines and exporting for multiple jobs would be very helpful.
- Dropping anomalous job execution times from stats would be helpful when exceeding maximum runtimes is important
- Idera SQL Diagnostic Manager
Other tools in the SQL Sentry Suite helped determine the purchasing decision. In particular the SQL Sentry Event manager product allowed us to easily connect and visualize the overnight process. Previously the overnight process was schedule driven and prone to fail as a result of upstream dependent job failures. Moving to an event driven model brought a great deal of stability to the night.
SolarWinds SQL Sentry Feature Ratings
Using SQL Sentry
15 - Sentry One users are typically DBAs and developers. We use it to monitor systems in production, evaluate development efforts and orchestrate overnight processes. For our organization the orchestration tools are the differentiate the product from other tools in the market.
5 - Database administrators and data developers get the most benefit out of Sentry One. In the absence of a network operations center, the light, fairly complete trace allow for us to know what happened while we weren't watching. Understanding the information presented and why it is important require an understanding of SQL server and Azure databases
- Monitoring SQL servers
- Orchestrating processes
- Projecting growth
- Finding inefficient processes
- Orchestrating shared scalable storage on analysis services
- Growing our orchestrations of processes
- More able to recover overnight process with limited intervention
- Less overnight support required
Evaluating SQL Sentry and Competitors
- Price
- Product Features
- Product Usability
The most important factor was the chain feature. When we were evaluating the product, we compared it to other DBA support tools, the monitoring features were very similar to many others on the market. It was the only tool that allowed us to rework complicated and fragile SSIS packages that were failing regularly.
Other products now allow for reasonably priced job management. This would make them more competitive and we would probably set up a test environment to run all of those products competitively. Ideras tools in particular are now more worth considering. However, familiarity and trust in the existing product is keeping us on the platform.
SQL Sentry Implementation
- Implemented in-house
Change management was minimal - Not many, the tool is used by DBAs and On Call support personnel. It required minimal training and was easy to get set up and going. Initially we spent a great deal of time testing upgrades but over time the upgrades have worked easily as a next / next/ finish change and they have become routine.
- Deciding which server to target
- Working out appropriate read only security
SQL Sentry Support
| Pros | Cons |
|---|---|
Good followup Knowledgeable team Problems get solved Kept well informed No escalation required Support understands my problem Support cares about my success Quick Initial Response | None |
Yes - Some have been. Others have taken a very long time to get corrected. At least one defect that we have reported some time ago (years at this point) remains uncorrected and we need to run a custom service to ensure that the chain feature works as expected. I have no idea when or if this will ever be resolved.
When were we having a terrible time with the chain feature, we were in regular contact with the architect of the feature and received multiple custom builds of the product until we were able to have a stable chain again. The defect was revenue affecting for us and was treated that way by Sentry One.
Using SQL Sentry
| Pros | Cons |
|---|---|
Like to use Relatively simple Easy to use Well integrated Consistent Quick to learn Convenient Feel confident using Familiar | None |
- Monitoring servers
- Creating an event chain
- Understanding the state of a monitored system in the past
- Customizing an alert with multiple filter conditions