Install SQL Server 2012 Performance Dashboard Reports

By: Ashish Kumar Mehta   |   Read Comments (3)   |   Related Tips: More > Monitoring

Problem

SQL Server 2012 Performance Dashboard Reports are Custom Reports which Microsoft has developed to quickly give an overview of the overall performance of SQL Server 2012 instance. Keep in mind that in order to use the Performance Dashboard Reports you don’t need to install SQL Server Reporting Services. In this tip we will take a look at how to install and use these built-in SQL Server Reporting Services Reports.

Solution

SQL Server 2012 Performance Dashboard Reports can be downloaded from the following link: http://www.microsoft.com/download/en/details.aspx?id=29063. The Microsoft Documentation states that “The SQL Server 2012 Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature of SQL Server Management Studio. The reports allow a database administrator to quickly identify whether there is a current bottleneck on their system, and if a bottleneck is present, capture additional diagnostic data that may be necessary to resolve the problem. The Dashboard reports basically retrieve information from SQL Server Dynamic Management Views and hence there is no additional overhead when using these reports.”

Common performance problems that the Performance Dashboard Reports may help to resolve include:

• CPU bottlenecks
  • What queries are consuming the most CPU?
• IO bottlenecks
  • What queries are performing the most IO operations?
• Index recommendations generated by the query optimizer
  • What are the potential missing indexes?
• Blocking
  • What blocking is occurring?
• Latch contention
  • What are the volume of latches?

Once you have successfully downloaded the SQL Server 2012 Performance Dashboard Reports then the next step will be to install the reports. Follow the steps below to complete the installation process.

Install the SQL Server 2012 Performance Dashboard Reports

1. Double click on the SQLServer2012_PerformanceDashboard.MSI and we are presented with the Welcome screen. Click Next.

2. Next we are presented with the License Agreement screen. Read License Agreement and Click Next.

3. For the third step we are presented with a Registration Information screen. Enter your registration information and then Click Next.

4. In the Feature Selection screen accept the default selection and click Next.

5. We're now ready to install. Click Install to start the installation process.

6. When you have reached this screen, the installation is now complete. Click the Finish button to exit the installation wizard.

Configure the SQL Server 2012 Performance Dashboard Reports

Once the Installation is complete, then the next step will be to configure the SQL Server to run the Performance Dashboard Reports. By default the Performance Dashboard Reports are installed in the “C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Performance Dashboard\” directory. Browse through the above mentioned location and double click the "setup.sql" file to open it in SQL Server Management Studio. Connect to the SQL Server 2012 instance where you want to install the reports and then press the "Execute" button or F5 to configure Performance Dashboard Reports.

Using the SQL Server 2012 Performance Dashboard Reports

Once you are connected to SQL Server 2012, right click on the SQL Server instance and expand Reports, then choose Custom Reports… as shown in the screen shot below.

Within the Open File Dialog box choose performance_dashboard_main report file as shown in the below snippet and click Open to display the report.

Once you open the performance_dashboard_main.rdl file using the dialog box, you're presented with the following warning screen. Click the Run button to display the report.

In the below screen shot you will see a sample Performance Dashboard Report generated in SQL Server 2012.

Next Steps

• Evaluate the remainder of the Custom Reports by selecting the links from the main report.
• If you have not had a chance to preview SQL Server 2012, then download SQL Server 2012 Evaluation Editionto start today.
• Download Microsoft SQL Server 2012 Performance Dashboard Reports.
• Stay tuned for more tips on SQL Server 2012and check out these related tips:
  • New Date and Time Functions in SQL Server 2012
  • New Logical Functions in SQL Server 2012 (IIF and CHOOSE)
  • New Data Type Conversion Functions in SQL Server 2012
  • Creating a SQL Server 2012 User Defined Server Level Role
  • SQL Server 2012 Contained Database Feature

Last Update: 4/26/2012

About the author

Ashish has been contributing to the MSSQLTips.com community since 2009 with over 60 tips.

View all my tips

We Recommend

• More SQL Server DBA Tips...

Comments and Feedback:

Thursday, April 26, 2012 - 9:17:13 AM - Saravanan	Read The Tip
Hello I installed the performance reports not once, but twice. I get the performance dashboard main but not the others. Could you please let me know how do I get them? Thanks!

Friday, April 27, 2012 - 5:07:09 AM - Ashish Kumar Mehta	Read The Tip
Dear Saravanan, To view other report you need to click on the hyperlinks. For example to view Historical information click on Waits or IO Statistics links in the main report. Regards Ashish Kumar Mehta

Wednesday, September 19, 2012 - 2:02:33 PM - jeff whittemore	Read The Tip
I get the setup.sql scripts to work in my instance but when I choose teh custom reports performance_dachboard_main.rdl and choose run I get this The file 'Microsoft.ReportViewer.WinForms, Version=9.0.0.0, Culture==neutral,PublicKeyToken=b03f5f7f11d50a3a' cannot be opened. Do you want to remove the reference to it from the Recent list?

Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name

*Email

Notify for updates Signup for our newsletter

Comments *** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a text editor like NotePad before copying the code below to remove the SSMS formatting.
*Enter Code

 

Sponsor Information

"Amazing, Amazing, Amazing! SQL doctor is truly one of the most powerful tools I have seen." SQL Monitor: prioritize your SQL Server workload with easy-to-use performance monitoring Need SQL Server help and not sure where to turn? Reach out to expert consultants in the USA for a Health Check. Free SQL Server performance monitoring software! Improve performance by 65% today with IgniteFree. SQL Server Data Tools - Got questions? Get the answers here!