Report Monitoring Console

BI xPress ›› Features ››
Parent Previous Next

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

  Longest Running Reports on Average

  Frequent Reports

  Active Users



Important Note:

Reporting Monitor Console is compatible with SSRS 2008 or later databases only.


After launching the Reporting plug-in for the first time, connection information for the SSRS database will need to be configured. Click the database connector icon located within the toolbar to launch the Reporting Database Connector.


 


Provide valid connection information and click connect.



Report Averages


The Report Averages panel displays the status of all executing reports present within your Reporting Services instance. The number of reports displayed can be adjusted using the dropdown menu in the header and 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.


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 displayed can be adjusted using the dropdown menu in the header and can be expanded by clicking the maximize report button ().


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 displayed can be adjusted using the dropdown menu within the header of the Report Averages panel and 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 using the dropdown menu in the header and can be expanded by clicking the maximize report button ().