SSRS Monitoring
The Report Monitoring Console provides users with the ability to monitor and troubleshoot their reports. The report console displays critical performance statistics, allowing users the ability to recognize performance issues and the overall health of their report server. Statistics such as memory usage, data and number of rows transferred are displayed as well as programmable thresholds.
Feature Highlights
• A high level overview of a report server
• Displays stats such as average runtime, average processing time, number of executions, amount of data transferred, and memory usage
• Shows the percentage of runtime that is consumed by processing a report
Table of Contents
• Longest Running Reports on Average
|
Reporting Monitor Console is compatible with SSRS 2008 or later databases only. |
Before launching the Reporting Monitor Console, users will need to enter connection information for the SSRS database that will be monitored. This can be done by navigating to the BI xPress Server Feature Settings page.
Within the Feature Settings page, users will need to provide connection information using SQL Server Authentication and then save the settings.
|
A user with the Workbench Server Administration action will be needed to configure the feature settings for the Report Monitoring Console. |
The Report Averages panel displays the status of all executing reports present within your Reporting Services instance. The number of reports can be adjusted from within the Feature Settings page using the "SSRS Monitoring Console - Most Frequent Reports Count" property. Additionally, the panel can be expanded by clicking the maximize report button (
).
Column Name |
Description |
Report Name |
The name of the report as defined in by the filename found on the reporting instance. |
Last Report Status |
Indicates the status of the most recent execution. |
No. of Executions |
The number of times this report has executed, either successfully or unsuccessfully. |
Avg. Runtime |
The average runtime of the report for all available executions. |
Avg. Data Retrieval Time |
The average amount of time it took for the reporting server to retrieve data from the report specified data sources. |
Avg. Processing Time |
The average amount of time it took for the reporting server to calculated and process the data retrieved from the data sources. Also, the amount of time it took to execute any formulas or expressions will be included in this value. |
Avg. Rendering Time |
The average amount of time it took for the reporting server to draw the report including graphics, images, text, and charts for all executions available. |
Avg. Data |
The average size of all data that was transferred to the reporting server for all available executions. |
Avg. Rows |
The average number of rows that were retrieved by the reporting server for all available executions. |
Avg. Max Memory |
The average value of the maximum memory consumption required by each report during execution. |
The Frequent Reports panel allows users to easily determine which reports are executing the most often. Reports that execute more than expected can cause the entire Reporting Services instance to run slow down, leading to performance and scalability issues. The number of reports can be adjusted from within the Feature Settings page using the "SSRS Monitoring Console - Most Frequent Reports Count" property. Additionally, the panel can be expanded by clicking the maximize report button ().
Longest Running Reports on Average
The Longest Running Reports on Average panel allows users the ability to easily determine which reports have been executing the longest and pinpoint bottlenecks within the Reporting Services instances. The number of reports can be adjusted from within the Feature Settings page using the "SSRS Monitoring Console - Longest Running Reports Count" property. Additionally, the panel can be expanded by clicking the maximize report button ().
The Active Users panel details a list of all users that have connected to the report server as well as the number of times the user has executed reports. The number of users can be adjusted from within the Feature Settings page using the "SSRS Monitoring Console - Most Active Users Count" property. Additionally, the panel can be expanded by clicking the maximize report button ().
