Reports Menus

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

SentryOne Reports Menu

Events Reports

SentryOne 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 SentryOne 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.SentryOne Current Failures
Management SummaryThe Management Summary report provides a high-level overview of the monitored servers in your SentryOne 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.SentryOne 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 SentryOne 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.SentryOne 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.SentryOne Watched Object Summary

Performance Analysis Reports

SentryOne Performance Analysis Reports

The Performance Analysis reports are the companion to SentryOne 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 SentryOne 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.SentryOne 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.SentryOne 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.SentryOne 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.  SentryOne 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).SentryOne 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).SentryOne 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.SentryOne 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.SentryOne 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.SentryOne 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.SentryOne 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.SentryOne SQL Server File Utilization Top Files

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.SentryOne 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 SentryOne environment.SentryOne 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.SentryOne Misaligned Partitions By Server
SentryOne 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).SentryOne High VLFs By Server
SentryOne 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.SentryOne 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 UserSentryOne Top SQL By User
- By DatabaseSentryOne Top SQL By Database
- By ApplicationSentryOne Top SQL By Application
- By ServerSentryOne Top SQL By Server
- All ServersSentryOne Top 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 ApplicationSentryOne Blocking By Application
- By Application MatrixSentryOne Blocking By Application Matrix
- By UserSentryOne Blocking By User
- By SQL ServerSentryOne Blocking By SQL Server
- By Wait ResourceSentryOne Blocking By Wait Resource
- By Wait TypeSentryOne Blocking 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 ApplicationSentryOne Deadlocks By Application
- By Application MatrixSentryOne Blocking By Application
- By ResourceSentryOne Deadlocks By Resource
- By SQL ServerSentryOne Deadlocks By Server
- By UserSentryOne 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.SentryOne 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.SentryOne Fragmentation and Usage

General Reports

SentryOne 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.SentryOne 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. SentryOne 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.SentryOne 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.SentryOne 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.SentryOne Downtime By Server