SQL Sentry

How to use performance analysis in SentryOne software (SQL Sentry) for SQL Server type targets, including Amazon RDS for SQL Server.

Articles

SQL Sentry Overview
What is SQL Sentry? SQL Sentry is a highly capable and scalable platform for enterprise data performance management. It's used to monitor, diagnose, and optimize Microsoft SQL Server environments. SQL Sentry collects and retains historical da...
SQL Sentry Performance Metrics
This article covers the various performance metrics displayed by the Performance Analysis Dashboard and Performance Analysis Overview, and how to interpret different metric values and combinations of values across different metrics for SQL Sentry.
Query Plans
Applies to: SQL Sentry and DB Sentry The Query Plans tab lists all plans collected for Top SQL completed queries for the specified date range, and provides a detailed chronology of all completed query plan changes. Use Query Plans to look b...
 Performance Analysis Processes
Guide to the Processes tab in Performance Analysis for Win Sentry, SQL Sentry, and BI Sentry.
 Performance Analysis Top SQL
Applies to: SQL Sentry, BI Sentry, and DB Sentry See the Monitor Top SQL article for an example of the Top SQL feature in a browser. The Top SQL tab lists all T-SQL batches, stored procedures (RPCs), and statement events collected ...
 Performance Analysis Disk Activity
Applies to: SQL Sentry, BI Sentry*, V Sentry*, and Win Sentry* *The Disk Activity and Disk Space tabs are focused on database files. For Win Sentry it applies to VMware and Hyper-V hosts for vDisks and VHDX files, respectively. The tabs ...
 Performance Analysis Disk Space
Applies to: SQL Sentry, BI Sentry*, V Sentry*, and Win Sentry* *The Disk Activity and Disk Space tabs are focused on database files. For Win Sentry it applies to VMware and Hyper-V hosts for vDisks and VHDX files, respectively. The tabs ...
 Performance Analysis Blocking SQL Updated
The Blocking SQL tab displays all SQL Server blocks that occurred during the active date range that meet the Minimum Block Duration . Each block is displayed in a hierarchical format, showing the relationships between all blocking and blo...
 Performance Analysis Deadlocks
The Deadlocks  tab displays information about deadlocks happening within your environment. Use the Deadlocks  tab to identify and correct deadlocks on your monitored servers. Deadlock Collection Deadlock collection is controlled ...
 Performance Analysis AlwaysOn
Access the SQL Sentry AlwaysOn Management page by right-clicking the All Targets node in the Navigator  pane and selecting Open > AlwaysOn Management . Open AlwaysOn Management from the context menu of any Sit...
 QuickTrace™
QuickTrace™ A QuickTrace   is a comprehensive snapshot of activity created by combining process-level data and trace events collected during a brief sample period. Various metrics such as CPU, I/O, recompiles, cache misses, cur...
 SQL Sentry Indexes
Applies to: SQL Sentry This feature is disabled by default. It can be turned on by using the in-app wizard. Indexes Tab The Indexes  tab displays information about your tables and indexes that are collected by the SentryOne Fr...
SQL Sentry Fragmentation Manager
Heavily fragmented indexes degrade the performance of your database and the applications running on it. Resolve index fragmentation by reorganizing or rebuilding an index. Fragmentation Manager automatically collects table and index information,...