SolarWinds SQL Sentry

To alert us of any issues with our SQL Server estate and to identify bottlenecks such as slow running queries so we can tune them for improved performance.

Production SQL Server implementations

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.

[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.

It helps to monitor SQL server performance monitoring with the help of graphs. ]The software] helps to identify the performance problems like long running quries on the database. [It] helps you to create best index for the given query. Daily running queries on [the] database can be easily viewed and its wait time can also be monitored.

[SolarWinds] SQL Sentry is well suited in [the] following cases: Nodes, availability, monitoring, query optimization, identification of problems, and increasing overall database performance. With the help of dashboards and graphs one can easily check all the important factors in one go. Network performance monitoring can be done easily. Databases can be monitored on AWS with the help of SentryOne.

The dashboard view of our server allows us to monitor the activity on our primary system and at a glance know if there is an issue. Getting to travel back in time and isolate performance issues is a huge bonus for us. We have been able to optimize and reduce issues with our database allowing our users to have a better experience with the dependent software. We also use it to monitor and plan our ETL jobs to not interfere with each other. In our regional community, we recommend others to SQL Sentry to monitor their Microsoft SQL instances.

Just had an end-user approach me about a long-running report. I was able to utilize the Top SQL tab and view the long-running report, copy the SQL being executed so I can place it in a notebook for later review for performance optimization. My manager looked in on the DBA Space earlier this morning to inquire about login issues for an application. As we had the dashboard loaded on our primary monitor, we were able to quickly glance and identify that the issue was not with the database. The issue was with a specific web server that was identified with other tools. We received a lot of calls in a short period of time with reports of 504 issues in the application. Using the Top SQL tab, identified that there was a report query being run multiple times that was causing table locks to not release. All these issues were identified in seconds with SentyOne. Most were resolved in under 60 seconds from the initial report of concern.

Our organization is using SQL Sentry to monitor a group of high-profile SQL Servers for performance problems. The DBA team relies on this tool to quickly resolve performance issues -- sometimes before the users even notice something is wrong. It also helps with long-term capacity planning by giving us historical trends of many useful metrics.

This solution is perfect for a team with a large server count and, at least, moderate experience supporting a SQL Server environment. If the environment is smaller or the team has less experience working with SQL Server performance tuning methodologies, then the tool may be overwhelming for the users.

I manage the department that is responsible for all of the company's databases. We use SolarWinds SQL Sentry for monitoring our SQL servers proactively as well as reactive troubleshooting.

Of all the tools I've used, SolarWinds SQL Sentry's Top Query has been the single most helpful tool in helping me identify which queries are putting a load on our servers and at what times. This greatly simplifies my job in prioritizing tuning. Having Plan Explorer directly linked to the tool is icing on the cake.

Sentry one is used to profile anomalies in the SQL Server like blockings, deadlocks and high CPU usage.

[Well suited to] Show top running queries and details like CPU usage and start time.

We have used SQL Sentry primarily for helping us monitor and proactively deal with performance issues with SQL Server. When we have a performance problem this tool has been quite helpful at reviewing past history and allow us to see patterns that may be causing us issues and helps us identify areas we can make changes to improve performance.

I feel this tool is ideally suited for monitoring performance issues in an OLTP environment maybe not so much for DW applications.

We are using SQL Sentry to centralize our SQL server monitoring from a number of differing domains. For the first time at this organization, we are getting a comprehensive view of our entire SQL estate. The previous solution was a mix of individual alerts on various SQL instances and several instances of a competing monitoring tool.

SQL Sentry is so flexible it's amazing. It comes with a steep learning curve and will take time to truly implement and dial in, but you're not alone--customer support is outstanding. My biggest complaint is that the thick client is slow and almost unusable over a VPN. Since COVID hit, that's a big deal. The web portal is snappy and fast, and I look forward to when the thick client is retired in favor of the portal.

We use SQL Sentry to monitor and alert on our SQL Server Environment. It helps us troubleshoot live issues as they occur using the dashboard and Top SQL. The history allows us to look back and investigate issues that have already happened. The built in baselines help us compare current metrics with historical norms. The dashboard gives us the a great view to analyze CPU, waits, disk latency and many other metrics on a single screen. There are some good out of the box reports. It is a powerful and flexible tool.

SQL Sentry allows the user to get a quick overview of the DB server and then drill into problem areas to get more details. The dashboard charts make it easy to snip and paste into Teams chats for the group to analyze. It seamlessly integrates with Plan Explorer for detailed analysis of the execution plan.