SolarWinds SQL Sentry

SolarWinds SQL Sentry

Customer Verified
Top Rated
Top Rated
SolarWinds SQL Sentry

Overview

Reviews

[SolarWinds SQL Sentry] in a Nutshell

9
We've purchased SolarWinds SQL Sentry in order to have eyes inside our database servers. From the moment that we rolled it out, people …
Read full review

SentryOne review

8
We use it to monitor our critical SQL server cluster and it is currently just used by the DBAs. It allows us to monitor in real time but …
Read full review

Why Switch to SQL Sentry?

10
SQL Sentry is being used to monitor 260 SQL instances across or enterprise. We are in the process of integrating the alerting capabilities …

SQL Sentry makes my job easier

10
We use SentryOne to monitor our Production SQL instances for the entire organization. We choose SentryOne as our monitoring solution to …
Read full review

SQL Sentry to keep an eye on things

9
We use SQL Sentry in my department to monitor patterns and fluctuations in performance for our SQL Servers. It's helped us address monthly …
Read full review

Great Performance Monitoring Tool

9
We have used SQL Sentry primarily for helping us monitor and proactively deal with performance issues with SQL Server. When we have a …
Read full review

Already impressed with SQL Sentry

10
We are using SQL Sentry to centralize our SQL server monitoring from a number of differing domains. For the first time at this …
Read full review

SQL Sentry - Best of Breed

9
Currently, we use SQL Sentry to monitor database performance and debug issues as they arise. I open up the dashboard for our production …

Popular Features

View all 5 features

Performance dashboard (101)

8.9
89%

Top SQL (101)

8.6
86%

Intelligent alerting (95)

8.3
83%

Historical trend data (99)

8.1
81%

Reviewer Pros & Cons

View all pros & cons

Pricing

View all pricing

Plan Explorer (SQL Server Query Tuning)

$0

On Premise
Free

SQL Sentry for Azure SQL Database

$161

On Premise
Per year per database (annual subscription)

SQL Sentry

1,450

On Premise
Per year per instance (annual subscription)

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttp://www.sqlsentry.com/portal/store

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Features Scorecard

SQL Performance Monitoring

8.1
81%

Product Details

What is SolarWinds SQL Sentry?

SolarWinds SQL Sentry is designed to help data professionals optimize SQL Server database performance in physical, virtual, and cloud environments. SQL Sentry delivers metrics to help users find and fix database performance problems and provides scalability, boasting demonstrated success monitoring 800+ SQL Server instances with one monitoring database.

With SQL Sentry, the user can monitor:

  • SQL Server
  • Azure SQL Database
  • SQL Server Analysis Services (SSAS)
  • SQL Server on Hyper-V or VMware VMs (including host)
  • SQL Server on Azure SQL Database Managed Instance
  • SQL Server on Amazon RDS
  • SQL Server on Amazon EC2
  • SQL Server on Linux

Although a SQL Sentry license can be used to monitor Azure SQL Database in a hybrid environment, dedicated licensing is available for large Azure SQL Database environments.

SolarWinds SQL Sentry Features

SQL Performance Monitoring Features

  • Supported: Performance dashboard
  • Supported: Intelligent alerting
  • Supported: Top SQL
  • Supported: Historical trend data
  • Supported: Virtualization support

Additional Features

  • Supported: Query plan analysis
  • Supported: Blocking and deadlock analysis
  • Supported: Event Calendar
  • Supported: Advisory Conditions
  • Supported: AlwaysOn Availability Groups monitoring
  • Supported: Index analysis
  • Supported: Storage Forecasting
  • Supported: SQL Sentry Portal (installed SQL Sentry web interface)
  • Supported: Environment Health Overview
  • Supported: Tempdb analysis
  • Supported: SQL Server Analysis Services (SSAS) monitoring

SolarWinds SQL Sentry Screenshots

SQL Sentry BlockingSQL Sentry DeadlocksSQL Sentry Index AnalysisSQL Sentry Top SQLSQL Sentry Performance Analysis Dashboard

SolarWinds SQL Sentry Downloadables

SolarWinds SQL Sentry Integrations

SolarWinds SQL Sentry Competitors

  • Redgate
  • Idera
  • Quest

SolarWinds SQL Sentry Technical Details

Deployment TypesOn-premise
Operating SystemsWindows
Mobile ApplicationNo

Alternatives

View all alternatives

Frequently Asked Questions

What is SolarWinds SQL Sentry's best feature?

Reviewers rate Performance dashboard highest, with a score of 8.9.

Who uses SolarWinds SQL Sentry?

The most common users of SolarWinds SQL Sentry are Mid-size Companies from the Computer Software industry.

Reviews

(1-25 of 159)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
  • Jobs management
  • Locking investigation
  • Performance analyze
  • Monitoring of AlwaysON
  • 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
[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.

  • We managed to identify our bottleneck in the chaos of thousands of queries.
  • We are able to identify our network issues from a maze of AlwaysOn synchronization servers.
  • Tuning queries got so much easier.
We had a use case several weeks ago where our SQL Server slowed down and the waiting tasks in the activity monitor ramped up to the thousands. The server wasn't down literally, but it felt like it as all of the applications were waiting to get their response from the SQL Server. Once we logged into [SolarWinds] SQL Sentry, we were able to track down what was the root cause and identify a rouge query that was overloading the server and causing locks for several tables.
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
  • Query analysis
  • More ways to monitor database performance
  • Graphical representation of different factors
  • Customized dashboards are good, but can be improved further.
  • More details can be shown to optimize query plan.
  • CPU and memory usage , availability can be shown in more different ways with additional details.
[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.
  • Optimized query plans are checked.
  • Helps to create proper indexes.
  • Executed SQL query can be easily identified in case of blockers , which further helped to fix the issue.
There was one blocker when [the] client was facing the slowness issue while adding the cart item. SQL Sentry helps to identify the scenario and long running query. It's difficult to monitor 24/7 the same manually but SQL Sentry helped to do that in order to understand the problem. Further, the suggestions and warnings were also helpful.
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
  • Real-Time Monitoring
  • Top Long Running SQL
  • Performance troubleshooting
  • Job Monitoring/Planning
  • Procedure and Query Statistics
  • Shiny Easy to use interface for those not comfortable with writing Queries
  • Integration with Azure Data Studio
  • A Containerized, platform agnostic web client
  • Support for Other Operating Systems
  • Support for other databases
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.
  • We've used the dashboard to observe that we had excessive recompiles occurring. The ability to identify the time that they were occurring allowed us to identify the procedure(s) and rewrite them to be performant without recompiling. The performance of our application and reporting improved after this.
  • We also used the dashboard to identify [trends] in SQL Server Waits. We were able to identify the jobs that were causing the SQL Waits to surge and optimize them. This resulted in further improvements to our user's experience with the dependent application.
  • We utilized the dashboard graph for backup speed to identify that backups were not processing for a chosen database. Once we identified this, we were able to modify the maintenance plan to get our backups back on track.
Our users got accustomed to having to log out every half hour from our principal application because of a cyclical performance issue. We were unaware of the performance issue as we weren't logged in as long as they were, only logging in to check on a data point or behavior of a controller before logging out again. After we got SQL Sentry, we were able to view a cyclical performance issue that consumed more memory than was needed for what was a simple and small result set returned. With the cycle identified, we were able to find the offending procedure and improve performance. Our users no longer were disrupted every 30 minutes and could instead use the application.
November 10, 2021

SentryOne review

Score 8 out of 10
Vetted Review
Verified User
Review Source
We use it to monitor our critical SQL server cluster and it is currently just used by the DBAs. It allows us to monitor in real time but also allows us to better understand why problems had happened so we can prevent them from reoccurring.
  • Monitors IO at multiple levels such as Storage, OS & Database level.
  • Top SQL provides a lot detailed analysis which allows you optimise queries
  • Alerting when setup correctly allow you to fix issues before users are aware.
  • Temp DB is not monitored and needs to be
  • Improved notifications like push
  • It has helped us optimize many queries
IO waits were high and we didn't know why but using SentryOne we established IO performance on the storage was reduced which then helped us identify a problem with one of our storage controllers. Without SentryOne it would have been impossible to show the storage team evidence of the issue.
Sometime I repeat myself and it takes a long time for bug releases.
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • The Top SQL functionality has been extremely useful for identifying poorly performing queries by resource consumption.
  • The flexibility of creating your own Advisory Conditions has allowed us to integrate our custom internal alerts into a centralized dashboard and alerting platform.
  • Being able to highlight any chart on the dashboard and then tool-matching that window across all the other charts makes it much easier to correlate the different performance metrics against each other.
  • While creating Advisory Conditions is extremely flexible it can be a bit challenging to get everything correct. Some sort of interactive tutorial would be really helpful.
  • The alert messages are very detailed, but it takes a bit to learn how to parse them. Some sort of enriched HTML format would be a nice quality of life improvement.
  • There are half a million configurable options in multiple places. Some sort of search feature would be fantastic.
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.
  • I was able to identify a process that was consuming 40% of a server's CPU. After tuning the process that load all but disappeared.
  • I was able to identify and tune a process that was causing multimillion reads down into the tens of thousands range.
  • I was able to identify and tune a process that was taking 5 minutes per execution down to 4 seconds.
Looking at the dashboard we could see that a server was running consistently at 80+% CPU and spiking to 100% for a few minutes multiple times per day. Using the Top SQL sorted by CPU we were able to identify a single query that was consuming over 90% of total CPU consumption. After turning that query the overall CPU load on the system dropped by 40%.
Mark Lessard | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
SQL Sentry is being used to monitor 260 SQL instances across or enterprise. We are in the process of integrating the alerting capabilities with SCOM via SNMP. Along with alerting SS greatly increase our efficiency in resolving ongoing and past performance issues. SS also provides a central repository for reporting at the enterprise and client level. We previously used a competitors tool for 7 years but moved to SQL Sentry due to the products inability to function in our environment and more so a lack of response to the issues we were experiencing by the vendor. Our experience with SQL Sentry support has been excellent to date.
  • Collecting and rolling up SQL statements with the associated plan. The ability to see aggregate and individual execution of SQL statements along with the associated plan is key in rapid diagnosis of bad plans. Bad plans are the most common performance issue we see in the big data environment.
  • The ability to drill into disk IO. Being able to easily see IO per a file can help identify issues with slow / stressed storage and or poorly distributed tables.
  • Easily focus on time-frame. Being able to click and drag to select a time frame to analyze from a prior time frame keeps maintains the flow of troubleshooting.
  • Alerting is inherited and highly configurable.
  • The collection can be distributed over multiple servers allowing scaling out horizontally and fault tolerance.
  • AD roles can be used in configuring access to the subsets of the servers being monitored. Access can be configured such that adding a user to an Active Directory role will provide access to just the servers then need to see. This works very well for our client specific operations.
  • The presentation of SQL server waits needs work. A large value on a throw away wait like cxpacket will change the scale such that an important wait like sos_schedular _yield is not readable. I have been told this is being addressed in the next release.
  • Installation of the client requires sysadmin access on the repository server for the initial install. Once the install is complete sysadmin can be removed.
  • There is a web interface but this does not have much of the functionality yet.
  • I have not found a way to view page splits over time.
I only see one scenario for this type of tool. I want all tools in this category to collect OS and SQL performance metrics over a time frame and present and or alert on them in a way that allows me to diagnose availability and performance issues on the servers. I need this information in real time and historically. I need to be able to report on this information at the micro and macro level. I need a tool that just works and a company that stands behind there tool. SQL Sentry meets these needs.

The only scenario I see were SQL Sentry would not work is were purchase cost of the product is weighted very heavily as opposed to all other factors.
  • We are more efficient in diagnosing performance issues. Time spent on this type or diagnosis has decreased by about 75%. The tool makes it much easier to discriminate between issues due to SQL and environment issues versus solution architecture and data distribution issues.
A common experience is the SQL optimizer choosing to use a loop join on a large join. We see this even after stats update with full-scan on the associated tables. We have tried the optimizer trace flag.

Process.
Find the SQL statement in Top SQL
Look at the historical run times/plans grid. Notice run time and color of dot. High run-time and different color, you have a bad plan.
Open the plan to review operators
Add hash join query option or join hints. I know this is not best practices according to MS, but the trade-offs in our OLAP environment make it the best choice.


They usually respond within a few hours and will pull in needed resources without the need for me to escalate the issue. They take the initiative to follow up. They are open to suggestions for future enhancements and actually implement them. They give the impression they want to resolve your issues.
I accept that the flexibility of the alerting comes at a price. Other than the alerting SQL Sentry's interface is intuitive. Connecting to a new SQL instance, given that all the needed ports are open in your firewalls is straight forward. Reviewing the performance and queries for an instance is available in with a right click. As you dig in new tabs are created to present the detailed data. I find the ability to filter and rollup metrics on a query very helpful in dealing with the "it's running slow". You can easily compare the metrics of run times for the same query to let the user know, it's probably data your doing a billion reads instead of the usual 100 thousand.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Sentry one is used to profile anomalies in the SQL Server like blockings, deadlocks and high CPU usage.
  • Problem detection
  • Alerts
  • Graphs
  • High resource usage
  • Calendar take time to load
  • incomplete execution plan
[Well suited to] Show top running queries and details like CPU usage and start time.
  • Find queries with high CPU usage
  • Long running queries detection
  • Details and scope of improvement
One of the recurring Stored procedures detected high CPU usage. Once detected, DBA and developers took care of it to tune it and after [it was] deployed, everything was good.
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
  • The performance dashboards are very useful and help bring attention directly to the problem areas.
  • The alerting system is extremely customizable,, so you don't get peppered with a bunch of useless alerts that make you blind to real action-worthy alerts.
  • The reporting is powerful enough to provide exactly what you need to see trends over time.
  • The alert customization is powerful, but can be cumbersome to set up.
  • There is so much information on the screen at any given time that without some practice it can be overwhelming.
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.
  • We are better able to predict performance issues by using alerting.
  • It is much easier to explain historical issues by using historical snapshots and reporting.
  • The different options for predicting future disk space usage has helped us in capacity planning.
We had an overnight interface that had been running longer and longer for no obvious reason. It was difficult to track down because no one was working in the late hours to see what was happening. Using the historical information stored and presented by SQL Sentry, we were able to see an unrelated job was running especially long due to a bad query plan and was negatively impacting the server performance as a whole.
Score 10 out of 10
Vetted Review
Verified User
Review Source
We specifically purchased SQL Sentry Performance Advisor out of the need to resolve performance issues on one of our SQL clusters. It was difficult to troubleshoot the issues after they had occurred and SQL Sentry allowed us to review the performance over a period of time and specifically go back to when an issue occurred to troubleshoot. We now use this for the majority of our SQL estate and specifically for IT Department only.
  • Historical analysis of performance counters - you can go back in time or over a range to see what was happening to the server
  • Review Top SQL and Blocking - You can see at a specific moment in time what queries are running and even review historical blocking.
  • Baselining - Ability to set your own baselines, so you can compare what is on screen to what you expect
  • Read only views - You can grant read only access to users, allowing us to grant support teams the ability to review the dashboards as well.
  • If a server is maxing out and unable to allow the service to record then you can get blackouts in the data. This is a risk of running as a service, but then you have bigger problems to deal with if that has occurred.
SQL Sentry can be utilised for both performance monitoring and alerting. It is good if you need to analyse performance issues whether in production or in development. Easily can export stats to send to vendors where applications are not performing well. And can setup alert thresholds that can send emails to support teams or write out to SCOM or the event log.
  • The tool has been invaluable with analysing performance issues. Being able to locate what blocking processes occurred overnight to resolve them via scheduling jobs at different times or rewriting stored procedures to run more effectively.
  • Great for analysis and to be able to send information to vendors as to why their applications might be deadlocking or running ineffectively if it is missing indexes or statistics are not up to date
Fairly recently we had a performance issue with a SQL Server consuming 100% CPU, with the performance advisor we was able to pin point the specific queries that were a problem and advise the vendor. Which lead the vendor to make recommendations and changes to their tables and jobs. This resolved the performance issue.
From their infancy as a smaller company to now as a global player they have always kept focus on prioritising he customer. They know their product and the technology it supports and are easily accessible for both resolving problems with the product all the way to adding value through additional training and assisting with getting return on investment through utilisation of the many features the product provides.
I don't know how we survived before without this tool, the added value that you get from it to do deep dive performance analysis, reactive problem solving and proactive monitoring and alerting is limitless. We have only scratched the surface of what we can do with this tool at my company. The support and ROI that SentryOne provide is exceptional and one of my favourite vendors to deal with.
Score 10 out of 10
Vetted Review
Verified User
Review Source
We use SentryOne to monitor our Production SQL instances for the entire organization. We choose SentryOne as our monitoring solution to reduce dependency on custom written alerts. This eliminates having to maintain custom alert compatibility with different versions of SQL Server and we are confident in the best practice standards SentryOne uses to develop their alerts. SentryOne is my first place to go when problems arise, and SentryOne is usually the first to let me know there is a problem.
  • Because of previous products, we had been accustomed to receiving emails for our alerts. SentryOne provides this functionality with great features like not using it for everything monitored to preventing our mailbox from being flooded by controlling alerts to a certain amount in a time frame (customizable) and an alert to tell you that limit has been reached.
  • SentryOne provides a great blocking page to help understand a blocking chain quickly. It is also configurable to ignore short term blocking that hasn't run long enough to be of concern.
  • Top-SQL has been a helpful feature to recognize processes or jobs that run beyond their normal run time. Also, helpful when looking for what was running during times an issue has come up and we need to see what was running in the past.
  • There is still some work to do with the baseline data. I am sure there are a great number of alerts that could be created using this data to highlight variations beyond normal.
  • All the alerts have the ability to trigger a response, providing some best practice configurations of these might help us to use these features more often.
  • Could use better documentation on the ports and firewall settings needed during the process of adding an instance to monitoring. This has proven to be different than what is used once monitoring is setup.
SQL Sentry has a very simple to follow layout for configuration and is easily adapted to each instance that has special requirements. Also, having the option to configure an alert to do more than one action is invaluable. Using the Alerting Channel, emails, and running scripts to address the issue automatically provides great value. Being able to set time windows of when to monitor and not monitor, as well as turning off all monitoring as needed by the server or reducing unneeded alerts during maintenance.
  • Charting with history and alerts have identified performance bottlenecks that previously had not been recognized.
  • Having immediate awareness of key issues has helped to mitigate them before performance reached a point of impact on users.
  • SQL Sentry has helped us to find when multiple processes collided causing a performance impact, allowing us to reschedule to avoid unnecessary overlap.
SQL Sentry monitors the entire server, so when it noticed an issue with high CPU and memory exhaustion, we knew how to configure the server to address both SQL performance and the other processes on the server that needed these resources. Adding resources without allocating them correctly would not have addressed the issue effectively. Knowing the other processes needed more CPU prompted us to use max dop to limit parallelism to not use all cores available.
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use SQL Sentry in my department to monitor patterns and fluctuations in performance for our SQL Servers. It's helped us address monthly spikes and unusual performance dips, so we know when we have a bug in just-released code and we know when to prepare for slightly-slower systems and address that accordingly.
  • offers good insight into data that would otherwise be time-consuming to compile
  • performance tuning
  • monitoring metrics
  • customization of alerts can be tricky
  • could have more granular data
  • summary reports could be more complete
SQL Sentry is a great monitoring tool for performance in environments that are transaction-heavy. It gives a complex overall view of performance on a daily/hourly/etc. basis so you know where spikes are happening (and when, more importantly). It also provides insight into blocking processes, so if you have a long-running query/job, you can see what's happening more clearly.
  • we're able to react to major performance bottlenecks before the user is affected
  • seeing patterns over time tells us where we can make code changes to improve performance
We had a major slow-down on one of our SQL server instances. Users were calling and complaining about time-out errors. With SQL Sentry we could see what the blocking process was, and a bit more information about it than what you get with the Activity Monitor. We were able to kill the blocking process after some assessment and performance improved.
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
  • Performance tuning.
  • Monitoring.
  • History tracking.
  • User interface could use some improvement.
  • Make it easier to drill down.
  • Add ability to set up more alerting.
I feel this tool is ideally suited for monitoring performance issues in an OLTP environment maybe not so much for DW applications.
  • Easier for us to see patterns of our SQL queries.
  • Helps us identify top performance issues.
  • Helps pro actively vs reactively manage our SQL instances.
We had an issue where SQL Sentry helped us identify a top slow performing query and what was causing it run slow. After we found this query SQL Sentry gave us some hints and direction as to what we would need to do to fix this problem. We used this data to then fix the problem and saw the performance improve over the next few days.
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • Metrics collection
  • Collects data across differing domains
  • SQL Plan Explorer is part of the tool
  • Alert configuration is amazing
  • Customer support is outstanding
  • No metrics for replication, but does alert
  • Thick client is slow and almost unusable over a VPN
  • The alert configuration is so flexible that it has a steep learning curve
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're starting to see areas for tuning improvement
We have had an issue with blocking, and with SQL Sentry we get an accurate picture of the point in time to see exactly what is happening on the SQL instance. Before, we were dependent on only using wait times for analysis.
Derek Knutsen | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Currently, we use SQL Sentry to monitor database performance and debug issues as they arise. I open up the dashboard for our production environment at the start of each day. We also use it to run our complicated weekly job that spans four servers. This job calls one server and then calls back to the originating server.
  • The unique offering is the graphical chaining of jobs. This is especially important when the job chain spans servers.
  • The graphs in the dashboard gives easy to follow and quick information as to the status of the database system.
  • The timeline of the job execution has been handy when seeing how long a job has executed or when a scheduled job could cause conflicts.
  • I wish there was a better way to determine what queries are running at a given time. This could be a resource problem, but I found myself going to profiler a lot.
  • Configuration of alerts is not intuitive. I want to create an alert for low disk space, but the interface was too obtuse.
  • Navigation is also not intuitive. You have to fumble around the tree structure to get to things like the job timeline.
SQL Sentry is good for overall monitoring and job configuration. There are capabilities for deep-dive troubleshooting. However, it is highly recommended to get training. Be prepared for a steep learning curve on how to get the system configured the way you want it. But, it is worth it. Do not expect this to be an all in one solution. This will not take care of backups.
  • A report was added to two locations in our application. That blew out the CPU. SQL Sentry was able to identify the times when heavy usage overloaded the system. We were able to identify the report as the root cause. And quickly fix it.
  • There was a poorly performing stored procedure that existed in the third party application we use. After an upgrade, the procedure caused our performance to drop. SQL Sentry was able to identify the queries that identified the procedure. We were able to put a patch in for the stored procedure.
  • In the process of adding a one-time job execution, I accidentally added another run of a maintenance job. The timeline view showed my error before the end of the day, allowing me to fix my error before it became a problem.
We were seeing regular spikes in CPU on our production environment. SQL Sentry identified these are coming from a Java process. The queries looked like a report without any criteria set. By sending the graphs and the sources of the queries, our report writers found that a test report was running against our production environment.
Kevin R. Zakoski | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
My team uses SentryOne to monitor our production SQL environment. They will use it as a first tool to verify system health when pulled into production issues. If SQL is determined to be the bottleneck in process, we'll use the information SentryOne provides to pinpoint the problem code and pass the information onto developers for fine tuning. In our development environment, our developers also have the client tools to monitor their processes. If we had licenses available for the Dev/Test servers, then we could fine tune them before releasing code to production. This is limited because we only have a few licenses to spare for Dev/Test.
  • It has an easy to use interface/dashboard; it doesn't require a lot training or reading to get information. Most of the key counters are on the main dashboard and the rest of the data you're looking for is usually just a tab away.
  • Historical information: By the time I get the call, the system is usually back to normal, so having the ability to look back in time and pinpoint when problems started is essential for us when determining the root cause of problems.
  • One tool: Not only can it determine what is causing the issue, SentryOne also captures the detail and plans for code being executed. It allow me to drill into the plans and get down to the nitty gritty code all within one interface. No need to buy additional tools or load into Management Studio to get more details.
  • Tuning advice: With all the graphs and data available, it's not always easy to determine the best thing to do. I'd like to see SentryOne provide some best practice analysis based on the historical information collected for the server being looked at.
  • They could add help tips or links to help documents, when you select a graph on the dashboard. Inexperienced users tend to put blinders on and focus on one thing when they see a high counter or something out of the ordinary. It would be very useful to include a link that provides underlying help. The link would provide an explanation of the counter in detail and offer possible explanations as to why the counter is off.
It has great out-of-the-box features that make it easy to install and get it up and running right away. However, fine tuning and customization of the solution, like setting up custom alerts and notifications, needs to be someones dedicated responsibility. Because of this, we don't necessarily have the time allocated to become true subject matter experts on the tool. What we get out of the box is usually going to be the norm.
  • It provides visual evidence you can provide to a developer that their code sucks. They're oblivious to query plans. Then you can show them that they are generating a billion plus reads and that allocating more memory and CPU isn't always the answer to their problems.
  • More often than not, SentryOne has proven that performance issues are usually not hardware related. It provides me the information I can put in a PM's hand stating that they need to allocate additional time and resources to fix poorly written legacy code. Code that needs to be updated using newer and more efficient practices.
We get hammered after quarterly releases and get inundated with performance calls asking what changed. Most think the DBA team is constantly changing configurations, etc. and must be the problem, because their test cases ran just fine. SentryOne has found numerous flaws in coding practices that they never looked at in Test and\or even tried running through the production workload. With evidence we provide from SentryOne, we're able to work in some temporary workarounds while the Dev team goes back to work to make a permanent fix.
It fairly easy to use with out of the box features and doesn't require a lot of customization. Interfaces are also easy to read and drill into to get more details when needed.
Kevin Dickover, PMP | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
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
SQL Sentry Performance Advisor is good at monitoring your system over time and allowing you to go back to previous problems to compare what was happening then to what is happening now. It is also good at reporting on harder to trap errors occurring in your system, memory pressure events in analysis services spring to mind here.

I've have heard of people trying to replace DBAs with this tool, that is a bad idea. This is a tool for DBAs, not a replacement.
  • We have found and corrected for badly constructed queries that were invisible to us in the overnight process
  • We have found users running badly constructed queries to SQL Server Analysis Services and stopped them
  • We have made reports of bad user behavior factual and backed by data when discussing them with senior leadership rather than the anecdotal reports that we previously had. This allowed us to correct behavior.
We had a job that ran overnight that started to go long and sometimes fail. PA history showed blocks and bad execution plans that allowed us to look for ways to correct the job. Eventually we rewrote the job so that the parallel executions that were causing the job to fail were eliminated.
The main platform is very well supported. Requests for help with customizing alerts and monitors have been rapidly and thoroughly responded to. Our use of the chain feature seems to be out of the ordinary and our defect reports there while understood and taken seriously, tend to be lower priority than defects in the main platform. They will work diligently to give us a workaround but correction in the standard release is a little slower in the chain feature.
As a general rule, out of the box use of the product is very easy. With little to no experience in the platform, we were up and running with it inside of 3 days. New developers and DBAs in the organization can get a grip on how to use monitoring features inside of half an hour.
Adrian Sullivan | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Reseller
Review Source
We use SQL Sentry to provide an agreeable set of monitoring metrics and results which we use as part of our consulting toolset for MS SQL server. It also forms the basis of our alerting and monitoring framework that we deploy for our clients.
  • Easy to implement
  • Great knowledge base
  • Excellent support
  • I'd like some customisable branding for reports
  • Having a customisable time allocation table to map alerts to an estimated, predefined chunk of time allotted to resolve the alert
SQL Sentry is amazing at getting information relating to the state of SQL servers. Alerts and issues are easy to consume as an action list.
  • Getting notified on SQL configuration enhancement opportunities has allowed us to more efficiently use hardware resources allocated to our SQL servers. This has greatly benefitted both us and our clients.
  • Having historic execution plans greatly speeds up our performance tuning related to the most resource intensive queries.
  • Our clients are finding noticeable improvements in application performance, which directly relates to optimisations based on SQL Sentry's output.
When troubleshooting performance issues on a SQL server we exhausted our normal tuning methods. We turned to SQL Sentry and found from monitoring data that this server was seeing a very high amount of Context Switches. This information pointed us to SQL server MAXDOP settings and VM CPU configuration issues. We would not have been able to find this information easily without using SQL Sentry to find the root cause.
Jian Fu | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use SQL Sentry to monitor our production database servers. We use it mainly for performance tuning for our environments. We also use it to analyse expensive queries, blockages, deadlock and so on. Then from the analysis, we apply optimizations accordingly.
  • It captures all relevant information about captured queries, from physical metrics to row counts. It packs all the information we need to analyse our database performance.
  • It provides a great graphic user's interface to have quick understanding of what is going in the environment, and gives facility to check historical values for the metric in question.
  • It could be improved on the way how the SQL Sentry database is managed, for example archiving old data, and also could have SQL agent jobs to do regular maintenance jobs to make it perform better.
  • Also it might be an good idea to have a web interface.
  • It would be good to be able to configure what kinds of queries to capture in each server instance.
I think SQL Sentry is typically useful for us to understand an environment with performance issues. With this product onboard, we are able to continuously improve our system to give our users the best experience.
  • It provides us long running queries with missing indices, and applying the indices to improve performance.
  • It provides deadlock monitoring, and we are able to analyse the deadlocks and reduce the deadlock occurrences.
We had a lot of situations where SQL Sentry came to rescue us. One of these situations was when we had a query running slow some times, and the majority of the it worked fast. SQL Sentry caught the execution statement and execution plan for us. After analysing the execution plan and parameter values, we found that the cached plan was not optimsed for a certain parameter values set. With this info, we deployed a plan guide to recompile this query, and then now it runs fast all the time.
May 01, 2020

Splendid Sentry!

Sharath K | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
SQL Sentry addressed one of our pain areas with accomplishing performance insights for critical trading system. It enabled performance insights for DBAs which was difficult to accomplish through native scripts.
Sentryone has added few new capabilities around monitoring SSAS which enhanced to expand our monitoring capabilities. It enabled proactive monitoring on cube failures and utilization.
  • AlwaysON Availability Pack.
  • SQL Plan Explorer- Very good utility
  • Easy to use Reports
  • BI monitoring capabilities
  • Sentry One cloud pack for high availability
  • Azure PaaS monitoring
  • Capacity Trending and Analysis
On Contrast to other vendors SQL Sentry stands top. Sentry one is doing good job in terms of connecting with SQL community and imparting the SQL knowledge.
  • Detection of Blocking queries which enabled us to resume AlwaysON on Asyc replica.
  • Deadlock Monitoring
  • Cube utilization and BI offerings
  • Trend analysis on top sql for performance trending and troubleshooting
Sentryone was able to fulfill our business needs with great customer support. I would recommend this tool as its very easy yo use and have got all the capabilities holistically to keep the database farm healthy with proactive monitoring.
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
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.
  • 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%.
I have always received prompt, professional support. Without fail, they are able to answer my questions and get things up and going.
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.
Score 10 out of 10
Vetted Review
Verified User
Review Source
We use SQL Sentry to help us identify performance issues and remediate them quickly. In addition, we use it to alert on blocking and deadlocks.
  • I like the way that the graphs on the dashboard can be selected and synchronize to show how each are related.
  • The ease at which problematic SQL can be identified by spikes on the dashboard make this tool invaluable to a Performance Engineering team.
  • We have a number of installations across different environments and solution lines. The tool needs to be able to switch between them within the tree view instead of needing to connect to a different installation from the file menu
  • We receive frequent timeouts when looking at the Top SQL tab on our busiest SQL servers with a lot of history. Something needs to be done on large repositories
SQL Sentry is very useful in production and performance testing environments for identifying and fixing slow performing applications. It is difficult on very high volume instances with a lot of history.
  • On one solution line, we resolved 3 lingering deadlocks that were part of the system for a long time on the first day we installed the tool.
  • On another team, we have proactively identified that fixed several cases that created production outages.
We installed SQL Sentry on a system where performance testing identified poor performance. On the first day, we identified three deadlocks that were the root cause of the performance issue. This was a few days before a very large and critical production release. The deadlocks were fixed and we doubled the number of concurrent users that the application could support.
  • no training
Thankfully, we have not needed to submit many support requests. I believe he have less than 5 cases in the last 4 years. However, when we do need support, the team is there for us.
For our organization, we find this tool to be the best for our needs in the Performance Engineering space. We love how quickly we can identify queries that need tuning and fix deadlocks. The user interface is simple to figure out. We would love to see the Sentry One client be more flexible to allow a single instance to show information from different repositories. We have three different installations of the tool for three different platforms. All three end up on slightly different versions at times, and that requires that users need to connect to a different machine to run the client since it has to match the back end repository. It would be preferable if it functioned more like SQL Server Management Server that is forward and backward compatible to a degree.
We are running 25 instances through a single monitoring service and it is able to keep up. We are finding that this many instances in our environment is about as many as can be handled. We will need to deploy additional monitoring services. Luckily, there is no additional licensing costs to deploy additional monitoring services. For us, it's just an additional Azure VM.
Yes
Nothing unexpected. The upgrades were simple to perform.
May 01, 2020

Force Multiplier

Score 10 out of 10
Vetted Review
Verified User
Review Source
As a Managed Service provider, SentryOne provides us with a key platform to monitor, diagnose issues and optimize performance for our customers. The platform provides the capability for services to be monitored 24/7 with in-depth, relevant information to be captured and reviewed for proactive and reactive cases, improving service delivery significantly.
  • Provides a fantastic review capability for historic data, collating data in a far more efficient, presentable way than you can with default tools. You know that if a customer experienced even the slightest performance dip overnight, you can review that to the finest detail later.
  • A highly customisable monitoring system, providing rock solid information which you can drill down to the smallest detail.
  • An outstanding Support Team, which continues to go above and beyond any expectations.
  • The perfect SQL Server monitoring platform.
  • Has the potential to make the business think they can replace DBAs with this fantastic product.
  • Windows Integrated Authentication for cross-domain monitoring (but you can monitor across domains, so this can be forgiven!).
A customer experiences a slow Analysis Services cube processing overnight from their Data Warehouse and wants to understand why this issue has occurred. SentryOne provides you the capability to see exactly what happened, with just as much detail as if you were sitting on the servers at 3:00am monitoring it directly. This applies for SQL Server, Windows, Azure, APS. Once you have experienced the product, you will realize you must have it.
  • Query optimisation improvements
  • Identification of key lookups / forwarded records which once addressed provided incredible performance improvements
A business intelligence application would intermittently take two to three times its normal duration to complete its processing run, causing significant business disruption. The workload was spread across multiple SQL instances and was a black box from a code perspective. SQL Sentry identified that the application was running multiple processing runs in parallel, but this wasn't visible from a customer perspective, as they only scheduled the run once.
The support received is outstanding. They are quick to respond, will happily speak with you on the phone, and go above and beyond on every single ticket to ensure that you have the best resolution, and provide a detailed breakdown around the problem, or if you are having issues understanding the metrics. The training / support materials alone that SentryOne provide are invaluable.
Users from SQL Server DBAs, Managers, to non technical Account Managers can drive the product, and the help function and resources provided enable anyone to double check any functions they aren't sure about, or even it its to analyse a particular chart or graph. But there aren't any issues with usability we've experienced.
June 25, 2020

SQL Sentry Review

Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • The performance dashboard makes it easy to get a quick overview of the current state of the DB server.
  • All monitoring tools have overhead. SQL Sentry does a good job of making the data collection as efficient as possible. I have seen performance issues with another 3rd party monitoring tool. I have not seen any with SQL Sentry.
  • Highlighting a significant period on the dashboard (like high CPU, large waits etc) and jumping to Top SQL is very handy.
  • There is a bit of a learning curve when setting up advisory conditions (ie alerts on specific metrics).
  • The Top SQL tab does a great job at big resource hogs. However the small, frequently executed queries are not as easy to analyze with this 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.
  • We have used it to help identify some blocking issues and then fix them.
  • Top SQL has helped us identify poorly performing queries that needed some enhancements.
We used SQL Sentry to help us identify queries that were causing CPU pressure on our system. Using the Top SQL and sorting by CPU allowed us to quickly zero in the queries that were consuming the most CPU. We were able to make adjustments to alleviate the CPU pressure.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Monitor production and development instances for benchmarking, baselining and troubleshooting. we shared access with devs, dbas and ops team to give full insight to the sql server performance. gave everyone a single view of issues and way to share issues or concerns across all teams. with enough rbac controls to keep things simple and secure
  • In-depth monitoring
  • Vast array of customisation
  • support
  • Documentation of customization
  • Configuration
  • explain what is being monitored and default alert values
Great for indepth monitoring where you can plug in 3rd party tool and know you are gathering everything needed to troubleshoot issues. If you dont have a datbase administrator, the amount of details gathered may be to large and set you off down the wrong path / give you red herrings for some issues
  • Baselining
  • Historical analaysis
  • Drill down troubleshooting
Event manager has helped solve multiple issues, both firing alert on real time events and allowing us to troubleshoot issues after the event, gather more details and obtianing proof the issue is resolved when using it with dev / prod. The inital review when simply turning it on highlights some bad configuration settings you may have as well
Great support from the team both pre and post purchase
  • in-person training
Great tool, captures lots of metrics to help diagnose and monitor performance
No
April 28, 2020

Pandemonium Control

Score 7 out of 10
Vetted Review
Verified User
Review Source
We use SQL Sentry within the IT department to help monitor and isolate issues associated with all production level database servers. SQL Sentry provides our IT department and DBA with the tools to quickly identify performance issues with our SQL Server databases. SQL Sentry offers us a centralized portal and a snapshot of our database servers health.
  • A centralized location to troubleshoot database server issues.
  • Quick access to pin in time snapshots database performance.
  • Capabilities to drill into problem areas.
  • Provide a query interface embedded into the application, so there is no need to bounce back between SSMS and SQL Sentry.
It is well suited for monitoring all servers in one consolidated interface, rather than bouncing around between different registered SQL Servers.
  • Yes, identified some problematic queries, and was able to proactively provide some performance upgrades after reviewing the query plan provided by SQL Sentry.
When the database performance drastically degraded one day, I was able to use SQL Sentry to isolate the issue to disk latency. Our engineers were able to move the vm onto a less taxed server, and performance returned.
Support has been great, but have had instances where the solution I desired was not inherently available in Task Factory.