SolarWinds SQL Sentry
Stop wasting time trying to fix SQL Server performance problems
Leverage DataOps observability to optimize database performance
Are you constantly fighting database performance fires, looking in vain for the root cause of SQL Server slowdowns?
Without the right information, you could waste valuable time looking in the wrong places for the answers to your performance problems. You need accurate, actionable, detailed metrics to quickly identify and address database problems. With SQL Sentry, you enable observability so that you can effectively monitor, diagnose, and optimize your entire database environment. SQL Sentry helps you get out of fire-fighting mode so you can keep your databases running continuously at peak performance.
SQL Sentry gives you the level of detail you need to find and fix SQL Server performance problems.
Monitor your entire data estate with SQL Sentry
Unleash SQL Server performance with these powerful capabilities
View detailed performance metrics
Performance Analysis Dashboard
See actionable performance information about your monitored servers in an easy-to-use Performance Analysis Dashboard that displays a graphical view of monitored server activity with "Jump To" navigation that lets you drill down to granular details.
Fix high-impact SQL queries
Top SQL
Frustrated by the time and effort it takes to identify SQL Server queries and procedures that are causing performance bottlenecks? The Top SQL view in SQL Sentry shows execution plan diagrams, query history, and more, so you can find and fix potentially problematic queries. The query analysis capabilities in SQL Sentry go far beyond what you'll find in SQL Server Management Studio (SSMS), giving you the information you need to quickly resolve problems.
Deadlock Analysis
Troubleshooting SQL Server deadlocks—where tasks are contending for resources—can be time-intensive and frustrating. Especially in complex deadlock situations, you could waste limited resources looking in the wrong place for the answer to the problem.
SQL Sentry Deadlock Analysis helps you quickly determine the root cause of the deadlock so you can restore the database to peak performance.
SQL Server Blocking Analysis
Although blocking is unavoidable, you need to be able to efficiently analyze blocking details to quickly identify the root cause—and understand the full impact—of a block.
With SQL Sentry, you can view all SQL Server blocks during a specified time range that exceed the minimum blocking duration and kill blocking processes with the click of a button.
TempDB Analysis
Tempdb is a single shared resource used by all your database processes. Contention in tempdb creates cascading performance problems across your SQL Server instance, which is why it’s critical to stay on top of tempdb health. The TempDB view in our web interface, SQL Sentry Portal, gives you insight into which applications and users are making use of tempdb and how. Easy-to-understand charts let you analyze tempdb file space utilization, objects, activity, and sessions to efficiently troubleshoot and optimize tempdb usage and prevent bottlenecks.
Event Calendar
Want to get the full picture of when SQL Server jobs and Windows Scheduled Tasks are scheduled to run so you can resolve potential conflicts? The SQL Sentry Event Calendar gives you a visual display in an Outlook-style calendar so you can ensure that every task and job will have sufficient resources to complete. The Event Calendar is one of the ways SQL Sentry helps you manage your SQL Server database proactively, so you can avoid unexpected database slowdowns that can negatively impact the business.
Storage Forecasting
Hate being surprised by insufficient disk storage space, which could bring your databases to a standstill? Storage Forecasting in SQL Sentry takes the guesswork out of planning storage needs by applying machine learning to forecast daily usage for all storage volumes across servers, helping you proactively
Monitor SQL Server Always On Availability Groups
SQL Sentry can automatically monitor Always On Availability Groups, which provide HA/DR capabilities in SQL Server. SQL Sentry gives you real-time insights into the state of your Always On environment. You can view the environment by Windows Server Failover Cluster node, by SQL Server instances, or by Availability Group.
Integrated Plan Explorer
Tune high-impact queries and plan a successful indexing strategy with Plan Explorer, which is integrated with SQL Sentry. Plan Explorer helps you troubleshoot poorly performing queries by giving you powerful index analysis capabilities, a visual display of query statistics, and query playback so you can see which operators are putting the most load on the system.
Environment Health Overview
The Environment Health Overview in SQL Sentry gives you a snapshot of your SQL Server environment health so you can easily prioritize troubleshooting activities to keep your database running at peak efficiency.
Event Chains
Managing multiple events such as SQL Server Agent jobs and Windows Scheduled Tasks to avoid resource contention across your environment can be challenging. SQL Sentry Event Chains help you create and analyze event workflows so you can identify and address potential performance problems.
QuickTrace
Want to get a clearer picture of how processes such as I/O, recompiles, cursor operations, and other activities are affecting database performance? SQL Sentry QuickTrace gives you a comprehensive snapshot of activity created by combining process-level data and trace events collected during a brief sample period.
Index Analysis
Successfully analyzing and managing SQL Server indexes can be frustrating and time-consuming. SQL Sentry Index Analysis gives you a sandbox environment so you can explore the impact of various index strategies before you implement them.
Enhanced Platform Installer
The Enhanced Platform Installer automates SQL Sentry software updates, saving you time and resources while ensuring your SQL Sentry solutions remain up to date.
After deploying the Enhanced Platform Installer, you can install any future updates by downloading the latest upgrade package, which updates all SQL Sentry monitoring services and sets all SQL Sentry clients to update at the next start. This innovative approach gives enterprises with large SQL Server environments optimal control over the upgrade process while shortening the deployment time.
Enterprise Scalability
SQL Sentry has proven scalability far beyond competitors' products, with demonstrated success monitoring 800+ SQL Server instances with one monitoring database. Our innovative use of SQL Server technology to scale monitoring to large enterprise workloads was the focus of a Microsoft profile. The article said that SQL Sentry "has shattered barriers to data ingestion and monitors its customer databases without impediment" and that SQL Sentry is built with current data management trends in mind.
Compare SQL Sentry editions
| SQL Sentry Feature | SQL Sentry |
SQL Sentry for Azure SQL Database |
| Number of licenses available | No cap on the number of licenses | No cap on the number of licenses |
| Data retention of Top SQL, blocking, and deadlocks | 15+ days | 15+ days |
| Performance Analysis Dashboard |  |
|
| SQL Server and Windows processes | |
|
| Top SQL view | |
|
| Environment Health Overview | |
|
| Integrated Plan Explorer | |
|
| Blocking SQL view | |
|
| Deadlocks view | |
|
| Alerting | |
|
| SQL Sentry Advisory Conditions Pack, plus custom Advisory Condition creation |
|
|
| SQL Sentry Portal | |
|
| TempDB analysis | |
|
| Index analysis and management | |
|
| Event Calendar and event management | |
|
|
||
| Disk Activity view and standard disk forecasting | |
|
| Advanced disk forecasting optimized with ML | |
|
| Scalability Pack | |
|
| Always On Availability Group monitoring | |
|
| Event Chain creation and management | |
Companies with the highest demands for database performance choose SolarWinds
