Sr. SQL Server DBA
Sr. Software Developer
Severstal NA, Greater Detroit Area
Verisk Health, Nepal
Data Warehouse Architect
BI xPress now makes monitoring and troubleshooting of SSRS reports easier by adding the Reporting Performance Monitor. The Reporting Performance Monitor will display critical performance statistics related to SSRS reports, including:
This report will show a number of statistics about the reports running on your server, including its name, status, and average runtime. Runtime is then broken down into data retrieval, processing, and rendering times. Times exceding user-configured threshholds will be highlighted to indicate which reports are struggling.
Longest Running Reports
Displays each report on the chosen server. Mouse over reports and to display their average runtime.
Displays a bar graph depicting the number of times reports have been executed.
Displays user names, and the number of reports each user has executed on the server.