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.
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.
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.
Proactively manage database performance and eliminate alert fatigue with Advisory Conditions that let you set relevant, actionable alerts based on conditions specific to your environment. With Advisory Conditions, you can automate responses to specific conditions, such as the results of a T-SQL query, a WMI query, a performance counter value, or any combination of values or queries.
With the SQL Sentry Portal, you can view important performance data for your monitored SQL Server, Azure SQL Database, and Windows targets in an easy-to-use web interface. The SQL Sentry Portal connects to your existing SQL Sentry database and includes core SQL Sentry capabilities, such as the Performance Analysis Dashboard, Top SQL, Environment Health Overview, and blocking and deadlocks 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.
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 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.
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.
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
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.
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.
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.
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.
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.
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.
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.
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.
|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|
|SQL Sentry Advisory Conditions Pack, plus
custom Advisory Condition creation
|SQL Sentry Portal|
|Index analysis and management|
|Event Calendar and event management|
|Disk Activity view and standard disk forecasting|
|Advanced disk forecasting optimized with ML|
|Always On Availability Group monitoring|
|Event Chain creation and management|
for Azure SQL Database
Companies with the highest demands for database performance choose SolarWinds