Infosys Microsoft Alliance and Solutions blog

« Games on Windows 8 | Main | SQL Server 2012: Distributed Replay »

SQL 2012 Performance Dashboard Reports

SQL Server performance dashboard reports are a set of custom reports which sit on top of SQL Server and can be executed directly through SQL Management Studio. These reports are meant for DBAs as well as developers. The goal of these reports is to help users identify and troubleshoot performance related issues.

To install the report files, one has to download the *.msi file from Microsoft site. A windows folder is created in the SQL installation folder consisting of rdl files and a script file for configuration. The script file needs to be executed on the server to be monitored for performance related issues. The executed script creates database objects (functions/stored procedures etc.) with the schema name as MS_PerfDashboard in the system database.

Once the script gets executed successfully, the performance dashboard can be accessed by opening the main dashboard report file through SQL Management Studio -> Custom Reports. Main Dashboard reports is an umbrella report which consists of various sub reports like database overview, session details, CPU utilization, query stats etc. There are also reports available to check wait times, missing index details; historical waits etc. which help in understanding and benchmarking performance problems the system is going through.

Please note that the most of the data shown in these reports only goes back till the last time server was restarted. Also, as these reports can be run directly out of SQL Management Studio, SQL Server Reporting Services (SSRS) installation is not required for executing these reports

For more detailed information and download details, you can refer to the below links:

http://www.microsoft.com/en-in/download/details.aspx?id=29063
http://www.mytechmantra.com/LearnSQLServer/Performance-Dashboard-Reports-SQL-Server-2012-P1.html

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam.

Subscribe to this blog's feed

Follow us on

Blogger Profiles

Infosys on Twitter