SQL Sentry Reports Menus

Accessing Reports

SQL Sentry offers a variety of built-in reports from the Reports menu.

SQL Sentry Reports Menu

Events Reports

SQL Sentry Events Reports

ReportsDescriptionsScreenshots
Current FailuresThe Current Failures report provides data about all failures that have occurred in the given time frame for any monitored objects in your SQL Sentry environment. The report includes various information about the associated failures including: name of the event, parent instance name, last step output, start and end times. Report parameters show either Open Failures only or All Failures. Any user notes added to the job failure instance are available on this report. Use the Current Failures report to identify object failures over the selected time frame.SQL Sentry Current Failures
Management SummaryThe Management Summary report provides a high-level overview of the monitored servers in your SQL Sentry environment. The report includes a count of all monitored objects, and as applicable, the associated number of failures recorded for those objects, grouped in the following ranges: last 30 days, last 7 days, and last 24 hours. Use the Management Summary report to help you determine which servers are the most active in your  environment.SQL Sentry Management Summary
Performance Counters ListThe Performance Counters List report provides data about Performance Counters currently associated with specific event objects or Custom Event Views within your SQL Sentry environment. Information about each Performance Counter is displayed for the specified time range, including the minimum, maximum, and average of the recorded metric. Use the Performance Counters List report to identify active Performance Counters in your environment.SQL Sentry Performance Counters List
Watched Object SummaryThe Watched Object Summary report provides information about the different types of objects found on each watched instance. The report breaks down the watched and unwatched objects by instance type and event source. Counts for the number of child objects belonging to the instance that are enabled or disabled are also provided in this report. Use the Watched Object Summary report to identify the number of monitored objects on your watched instances.SQL Sentry Watched Object Summary

Performance Analysis Reports

SQL Sentry Performance Analysis Reports

The Performance Analysis reports are the companion to SQL Sentry Performance Analysis. For more information about the various metrics contained in the Performance Analysis reports, see the Performance Metrics topic.

Note:  On applicable reports, the Load Saved Parameters drop-down box allows the user to save the parameters for future use.

Performance 

ReportsDescriptionsScreenshots
Global Server PerformanceThe Global Server Performance report provides a summary of the performance metrics collected for each of the servers in your SQL Sentry environment. Use the Global Server Performance report in conjunction with the Performance Analysis Global view for a high-level understanding of server performance across your entire monitored environment.SQL Sentry Global Server Performance
Performance Counter Date Range ComparisonThe Performance Counter Date Range Comparison report provides graphical and textual data for the selected Performance Counter(s) over the specified time range. Various parameters can be configured including: Server, Instance, Category, Counter, and Instance. This report is like the Performance Counter History report, except two different time ranges can be selected.SQL Sentry Performance Counter Date Range Comparison
Performance Counter HistoryThe Performance Counter History report provides both graphical and textual data for the selected Performance Counter(s) over the specified time range. Various parameters include: Server, Connection, Category, Counter, and Instance that can be configured.SQL Sentry Performance Counter History
SQL Server PerformanceThe SQL Server Performance report provides detailed SQL Server performance data for the instance over the selected time range.  Use the SQL Server Performance report in conjunction with the Performance Analysis dashboard to gain an understanding of SQL Server performance in your monitored environment.  SQL Server Performance
SQL Server Transactions - Top DatabasesThe SQL Server Transactions - Top Databases report provides detailed data about transactions and log flushes for the selected instance over the specified time range. The report includes a minimum, maximum, average, and total column for each metric. The report includes the top 10 databases for the instance as determined by the total number of log flushes and transactions.
SQL Server Wait Stats AnalysisThe SQL Server Wait Stats Analysis report provides detailed data about SQL Server waits for the instance over the selected time range. Several aggregate waits groupings are incorporated into the report, including waits by category, by class, and by type. Each grouping breaks down the waits data by Resource Waits, CPU Waits, and Total Waits. Metrics are displayed in milliseconds (MS).SQL Sentry SQL Server Wait Stats Analysis
SQL Server Wait Stats Analysis - By Resource and CPU WaitsThe SQL Server Wait Stats Analysis - By Resource and CPU Waits report provides detailed data about SQL Server waits for the instance over the selected time range. Several aggregate waits groupings are incorporated into the report, including waits by category, by class (CPU or Resource), and by type (CPU or Resource). Metrics are displayed in milliseconds (MS).SQL Server Wait Stats Analysis By Resource and CPU Waits
SSAS PerformanceThe SSAS Performance report provides detailed graphical information regarding the SSAS performance for the selected instance over a given time range.SQL Sentry SSAS Performance
Windows + SQL Server PerformanceThe Windows + SQL Server Performance report provides detailed performance metrics for each instance on the selected server regarding Windows and SQL Server performance. Use the Windows + SQL Server Performance report in conjunction with the Performance Analysis dashboard to gain an insight into the performance of your monitored environment.Windows SQL Server Performance
Windows PerformanceThe Windows Performance report provides detailed Windows performance data for the instance over the selected time range. Use the Windows Performance report in conjunction with the Performance Analysis dashboard to gain an understanding of Windows Performance in your monitored environment.SQL Sentry Windows Performance

Disk / File Space

Use the Disk/File Space reports in conjunction with the Disk Activity and Disk Space tabs of Performance Analysis to identify data disk capacity issues and possible performance bottlenecks.

ReportsDescriptionsScreenshots
SQL Server File Growth -Top Files - All ServersThe SQL Server File Growth - Top Files - All Servers report provides data and log file growth over the selected time range for the Top N files, as selected in the report parameters, across your entire installation. There are representations for total size and used size over the selected time frame.SQL Server File Growth Top Files All Servers
SQL Server File Utilization 
- Top Files
- By Logical Disk
- By Database
The SQL Server File Utilization report provides data and log file growth over the selected time range for the Top 5 files on the specified instance. There are representations for total size and used size over the selected time frame. Each of the SQL Server File Utilization reports group the data by its respective category name.SQL Server File Utilization Top Files

Windows Disk ForecastThe Windows Disk Forecast report provides the amount of space you've already used and provides an example of to how to expand the volume of your disk space so that you don't run out in the future.

  • All Servers—Displays all volumes that will run out of memory within a specified time frame. 
  • Individual Servers—Capacity planning that provides a secondary chart with a forecasted amount of disk space. 
Windows Disk Utilization - By ServerThe Windows Disk Utilization -By Server report provides the amount of used and free space for the selected server over the specified time range. The report provides data for both Physical and Logical disk utilization.Windows Disk Utilization By Server
Windows Disk Utilization - All ServersThe Windows Disk Utilization - All Servers report provides the disk size, used space, free space, and used space history for all the monitored servers within your SQL Sentry environment.Windows Disk Utilization All Server
Misaligned Partitions - By Server
- All Servers
The Misaligned Partitions reports provides a summary of the misaligned partitions for the selected server.Misaligned Partitions By Server
Misaligned Partitions All Server
High VLFs 
- By Server
- All Servers
The High VLFs reports provides data about transaction logs that have a high number of Virtual Log Files (VLFs).High VLFs By Server
High VLFs All Server
Databases without Recent BackupsThe Databases without Recent Backups report provides information about databases without a recent backup in your monitored environment. Information is included for both data and log files, including the Last Backup Time, Last Backup Type, and Used Size (MB). The default time range for this report covers the last 15 days, but is configurable. Transaction Log files aren't included in this report if the database is in simple recovery.SQL Sentry Databases Without Recent Backups

Top SQL

ReportDescription
Top SQL The Top SQL reports provide a summary of Top SQL data captured over the given time range. Top SQL contains high impact, worst performing stored procedures, batches, and statements. The information captured by Top SQL can be based on any combination of duration, CPU, reads, or writes. Use this data along with other metrics available in the Top SQL tab of Performance Analysis to identify and target problem areas. Each of the Top SQL reports group the Top SQL data by its respective category name.
- By UserSQL Sentry Top SQL By User
- By DatabaseSQL Sentry Top SQL By Database
- By ApplicationTop SQL By Application
- By ServerTop SQL By Server
- All ServersTop SQL All Servers

Blocking

ReportDescription
BlockingThe Blocking reports provide a summary of blocking data over the given time range. They are designed to aggregate by blocking query, blocked query, and wait resource for the selected time frame. Use this data along with other blocking-level metrics available in the Blocking SQL tab of Performance Analysis to identify and target problem areas.
- By ApplicationSQL Sentry Blocking By Application
- By Application MatrixBlocking SQL By Application Matrix
- By UserSQL Sentry Blocking By User
- By SQL ServerBlocking By SQL Server
- By Wait ResourceBlocking By Wait Resource
- By Wait TypeBlocking By Wait Type

Deadlocks

ReportDescription
Deadlocks The Deadlocks report provides information regarding Deadlocks in various ways over a specified time range. When used in conjunction with the Deadlocks tab in Performance Analysis, these reports can help track down problematic Deadlocks.
- By ApplicationSQL Sentry Deadlocks By Application
- By Application MatrixBlocking By Application
- By ResourceDeadlocks By Resource
- By SQL ServerDeadlocks By Server
- By UserSQL Sentry Deadlocks By User

Fragmentation Manager 

ReportsDescriptionsScreenshots
Index Defragmentation Details - By DatabaseThe Index Defragmentation Details report provides a summary of the defragmentation details for the indexes in your environment. Defragmentation metrics provided include fragmentation percentages, defrag method, fragmentation percentage post defrag, and start/end times.Index Defragmentation Details By Database
Index Fragmentation And UsageThe Index Fragmentation and Usage report provides a graphical representation of the overall fragmentation, disk space usage, and buffer usage of the indexes in your environment.Fragmentation and Usage

General Reports

SQL Sentry General Reports

ReportDescriptionScreenshots
Action CountsThe Action Counts report provides a count, broken down by object and parent object, of actions that have taken place during the selected time range. This report gives you valuable information for adjusting alerts in your environment. Use the Action Counts report to quickly identify where the alerts in your environment are coming from, and then make adjustments as needed.SQL Sentry Action Counts
Active Settings ListThe Active Settings List report provides details on every setting configured in your environment at all levels combined into one resource. This report gives you valuable information about how settings are effecting your configured actions and collection settings. SQL Sentry Active Settings List
Configured Actions ListThe Configured Actions List report provides a list on every action that's configured for a given condition, specifying at what level the action's configured.SQL Sentry Configured Actions List
Configured Notification ListThe Configured Notification List report allows you to view all conditions that are specifically configured to send notifications by email or pager.SQL Sentry Configured Notifications List
Downtime - By ServerThe Downtime - By Server report provides a listing of all server downtime activity for the specified time range. Included in the reports are metrics such as total incidents, total downtime in seconds, average downtime per incident, uptime percentage, and first/last incident times.Downtime By Server