I have developed a set of reports which are intended to be used in SSMS as Custom Reports for the Report Server database.
As you know, each instanc eof SQL Server may have its own Report Server database, and also the DBA who installs and configures the SSRS can give any name to the Report Server database. The SSRS Performance Dashboard reports work regardless of the name of the database and the instance.
The reports run queries to the Report Server database and present information rendered within SQL Server Management Studio.
Note: use the reports at your own risk and always consider performance when executing queries or reports on production systems.
The SSRS Dashboard reports are provided to you as a ‘good will’ gesture, and it is up to you to use them in a smart way. If you encounter bugs or problems or if you have questions – drop me a line and maybe I could help.
Product name: SSRS Performance Dashboard reports (Version 1.0.0)
Created by: Feodor Georgiev
Release date: November 21, 2011
Screenshots: For some screenshots click here.
Installation: For a short video explaining the reports, click here.
Feedback: Any feedback is highly appreciated. You can use the Contact Me form.
Download: For download use this link: SSRS Dashboard (3949)
Cup of coffee: If you feel like buying me a cup of coffee or if you just like my reports dashboards, feel free to donate any amount you’d like (in USD) by using the PayPal button below:
This product contains a set of reports for SSMS (SQL Server Management Studio) which explore the performance, configuration and security of SSRS (SQL Server Reporting Services). These reports work with SQL Server versions 2005 and up.
Features in this release:
This release contains total of 17 reports grouped in 2 categories: “Security and config” and “performance and object statistics”.
The reports included are:
Security and config:
- Get All Configurations
- Folders And Permissions
- List Users And Roles
- Search For Objects In Adhoc
- Stored Procedures List
- List Adhoc Queries
Performance and object statistics:
- Rendering Types And Counts
- Most Frequently Used Reports
- Object Statistics By Object Type
- Cache Expiration
- Report Averages Statistics For all Reports
- Report Exec Statistics For Each Report
- Reports With Longest Data Retrieval
- Most Frequent Report Users
- Get The Latest Reports Delivered
- List Currently Running Jobs
- Recently Failed Reports
SQL Server 2005 and up.
SQL Server Management Studio.
Download the zipped file from the location above and save it to your computer or server. Unzip it in a location chosen by you.
In order to run the reports, open SSMS and connect to an instance of SQL Server which is hosting the Report Server database. Right-click on the Report Server database name in SSMS and select Reports –> Custom reports. At the prompt navigate to the folder of SSRS Dashboard reports and select the SSRSDashboard_Main.rdl file.
The Default trace report should open in your SSMS. Just click the links and enjoy.
In order to run the reports you need to be a data reader of the Report Server database.
For F.A.Q.s click here.
Do not hesitate to drop me a line if you have questions or comments. You can use the Contact Me form.