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.
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.
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.
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.
SQL Server Deadlock Analysis
SQL Server Deadlock Analysis is a SQL Sentry capability that help DBAs find and fix SQL Server deadlocks.
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.
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.
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
