[SolarWinds SQL Sentry] in a Nutshell
Rating: 9 out of 10
IncentivizedUse Cases and Deployment Scope
We've purchased SolarWinds SQL Sentry in order to have eyes inside our database servers. From the moment that we rolled it out, people were excited to use it and couldn't believe that such a tool exists [that] can provide so many details on the queries and performance inside the server. It has helped us to discover performance issues, bugs, and much more.
Pros
- Jobs management
- Locking investigation
- Performance analyze
- Monitoring of AlwaysON
Cons
- Creating smoother integration to 3rd part tools, such as Slack, PagerDuty, etc.
- Adding the ability to have an option for adding custom metrics defined by user queries
- Adding more dashboards and visibility into the SQL Sentry Portal
Likelihood to Recommend
[SolarWinds] SQL Sentry is well suited for any production SQL Server that has performance issues or a need to look into the guts of the server itself. Using the very specific features that are targeting SQL Server, you can see that every feature you use was described by the hands of a DBA and it is suited to be used by one. It is not suitable to be used with other database technologies at the moment.