Report Monitoring Console


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

  Report Averages

  Frequent Reports

  Longest Running Reports on Average

  Active Users



Important Note:

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.



Important Note:

A user with the Workbench Server Administration action will be needed to configure the feature settings for the Report Monitoring Console.


Report Averages


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.


Frequent Reports


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 ().

 

Active Users


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 ().