SQL Sentry Features Overview

 

Explore key capabilities that set SQL Sentry apart.

 

SQL Server Performance Monitoring Features

 

Top SQL

Top SQL is a user interface that displays long-running and high-impact queries so you can easily troubleshoot SQL Server performance problems. With sortable grids, runtime charts, and index and statistical analysis, you can quickly determine root cause, prioritize issues, and move on to the next problem.

Learn More

Advisory Conditions

Advisory Conditions are a proactive alerting and response system that helps you customize notifications based on parameters that are specific to your environment. By using pre-built or customer Advisory Conditions, you can anticipate and prevent database performance problems.

Learn More

Performance Analysis Dashboard

The Performance Analysis Dashboard gives an overall snapshot of database environment health across the Microsoft Data Platform. You can easily drill down into details to uncover the root cause of performance problems. 

Learn More

Event Chains

The Event Chain feature in SQL Sentry helps you set up SQL Server event workflows so that SQL Server jobs, Windows scheduled tasks, and other events execute automatically and in a specific order to avoid potential conflicts.

Learn More

SQL Server Deadlock Analysis

SQL Server Deadlock Analysis is a SQL Sentry capability that help DBAs find and fix SQL Server deadlocks.

Learn More

Event Calendar

With the Event Calendar, you can identify and fix potential conflicts between multiple events—such as SQL Server jobs or Windows scheduled tasks—competing for the same resources, which can slow database performance. 

Learn More

Index Analysis

Index Analysis is a capability that presents actionable information to help you make smart decisions about SQL Server index management, which can help speed performance of your databases. 

Learn More

Storage Forecasting

SQL Sentry Storage Forecasting, powered by machine learning, produces daily usage forecasts for storage volumes across servers, enabling data professionals and IT managers to proactively manage compute resources for multi-cloud and hybrid environments.

Learn More

SQL Server on Linux

SQL Sentry offers comprehensive database performance monitoring, diagnosing, and optimization capabilities for SQL Server 2017 on Linux. While not all the scenarios and features covered by SQL Server on Windows are supported by Microsoft on Linux yet, SQL Server 2017 on Linux is ready to support transactional and data-warehousing workloads, as well as Availability Groups.

Learn More

Always On Monitoring

SQL Sentry provides a rich set of performance analysis capabilities to efficiently manage and monitor any SQL Server AG environment. The AlwaysOn Management tab in SQL Sentry displays information about your AG environment, including overview diagrams with complete topology, a detailed-level grid view, and historical charting.

Learn More

SentryOne Portal

Easily access SQL Sentry monitoring dashboards and query analytics from a browser with SentryOne Portal. This easy-to-use web interface connects to your SentryOne database and displays real-time and historical performance data for your monitored SQL Server, Azure SQL Database, and Windows targets.

Learn More

TempDB Analysis

The TempDB view in our web interface, SentryOne Portal, gives you enhanced visibility into tempdb activity and usage. You can easily analyze key tempdb health and utilization metrics to troubleshoot and prevent performance bottlenecks and optimize tempdb configuration.

Learn More

SQL Server Analysis Services (SSAS) Performance Monitoring Features

 

MDX and DAX Query Analysis

MDX and DAX query analysis, a capability available in SQL Sentry, provides in-depth details about SSAS queries so that you can analyze the impact of MDX query performance in Multidimensional mode and DAX query performance in Tabular mode.

Learn More

Top SSAS Commands

The Top Commands tab shows SSAS query-level collection and any MDX, DAX, or XMLA commands that have run longer than one second. All the like queries have been rolled up and grouped together so that you can see their total impact. 

Learn More

SSAS Usage Totals

The SSAS Usage Totals tab provides information that can be used to determine what responses to take based on activity levels. This information is divided into three different groups: Attributes, Aggregations, and Partitions.

Learn More

SSAS Performance Metrics

The SSAS Performance Metrics displayed by the Performance Analysis Dashboard give you valuable insight into the root cause of performance problems with SSAS. With actionable information, you can save time in troubleshooting SSAS performance.

Learn More

SQL Server on Hyper-V Performance Monitoring Features

 

Windows Performance Metrics

Using detailed information for network, CPU, system memory, and disk IO usage for your Windows Server and Microsoft Hyper-V environment, you can troubleshoot potential resource problems that could slow your SQL Server performance.

Learn More

Hyper-V Host Monitoring

Microsoft Hyper-V offers enterprise-class virtualization for organizations who want to virtualize workloads, build a private cloud, scale services through a public cloud, or combine all three.

Learn More

Performance Analysis Baselining

SQL Sentry allows you to monitor your SQL Server environment against baseline performance metrics. The platform provides pre-defined baselines based on historical time ranges as well as custom baselines.

Learn More

SQL Server on VMware Performance Monitoring Features

 

CPU and Memory Usage Metrics

SQL Sentry provides visibility into your virtual environment so that you can analyze network, CPU, memory, and storage for VMware hosts and virtual machines (VMs). Knowing CPU and system memory usage helps you troubleshoot SQL Server performance problems that are caused by problems in the virtual environment. 

Learn More

Windows Disk Activity and Disk Space Analysis

Disk Activity and Disk Space are two tabs in SQL Sentry that provide information about Windows disk activity and disk space usage that could be affecting the performance of your SQL Server database or other processes. 

Learn More