SentryOne Product Features Overview

 

Explore key capabilities that set SentryOne apart.

 

SQL Sentry 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.

You'll find this feature in: SQL Sentry, Plan Explorer

Learn More

Advisory Conditions

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

You'll find this feature in: SQL Sentry, Win Sentry

Learn More

Performance Analysis Dashboard

The SentryOne 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. 

You'll find this feature in: SQL Sentry, Win Sentry, BI Sentry, DB Sentry, DW Sentry, APS Sentry

Learn More

Event Chains

The SentryOne Event Chain feature 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.

You'll find this feature in: SQL Sentry, Win Sentry

Learn More

SQL Server Deadlock Analysis

SQL Server Deadlock Analysis is a capability of SentryOne database monitoring products that help DBAs find and fix SQL Server deadlocks.

You'll find this feature in: SQL Sentry, Plan Explorer

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. 

You'll find this feature in: SQL Sentry, Win Sentry, BI Sentry, DB Sentry, DW Sentry, APS Sentry

Learn More

Index Analysis

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

You'll find this feature in: SQL Sentry, Plan Explorer

Learn More

Storage Forecasting

SentryOne 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

SentryOne 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, detailed-level grid view, and historical charting.

Learn More

 

BI Sentry:

 

MDX and DAX Query Analysis

MDX and DAX query analysis, a capability available in SentryOne BI Sentry, provides in-depth details about SQL Server Analysis Services (SSAS) queries so you can analyze the impact of MDX query performance in  Multidimensional mode and DAX query performance in Tabular mode.

You'll find this feature in: BI Sentry

Learn More

Top SSAS Commands

The BI Sentry Top Commands tab shows SQL Server Analysis Services (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 you can see their total impact. 

You'll find this feature in: BI Sentry

Learn More

SSAS Usage Totals

The SentryOne SSAS Usage Totals tab in SentryOne BI Sentry 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.

You'll find this feature in: BI Sentry

Learn More

SSAS Performance Metrics

The SSAS Performance Metrics displayed by the Performance Analysis Dashboard in SentryOne BI Sentry give you valuable insight into the root cause of performance problems with SQL Server Analysis Services (SSAS). With actionable information, you can save time in troubleshooting SSAS performance.

You'll find this feature in: BI Sentry

Learn More

Win Sentry:

 

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.

You'll find this feature in: SQL Sentry, Win Sentry

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.

You'll find this feature in: Win Sentry

Learn More

Performance Analysis Baselining

The SentryOne Monitoring Platform allows you to monitor your SQL Server environment against baseline performance metrics. The platform provides predefined baselines based on historical time ranges as well as custom baselines.

You'll find this feature in: SQL SentryWin SentryBI SentryV SentryDB Sentry

Learn More

V Sentry:

 

CPU and Memory Usage Metrics

SentryOne V Sentry provides visibility into your virtual environment so 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. 

You'll find this feature in: V Sentry

Learn More

Windows Disk Activity and Disk Space Analysis

Disk Activity and Disk Space are two tabs in SentryOne Win 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. 

You'll find this feature in: Win Sentry, V Sentry

Learn More