About the Post

Author Information

New Tool: Microsoft® SQL Server® 2012 Performance Dashboard Reports

I been meaning to blog about this great feature for some time. It was released earlier this year, like way back in March of 2012. It is a report of your SQL server’s health in a very quick method and it is very simple, plus easy to install.

Overview

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.

Common performance problems that the dashboard reports may help to resolve include:

  • CPU bottlenecks (and what queries are consuming the most CPU)
  • IO bottlenecks (and what queries are performing the most IO)
  • Index recommendations generated by the query optimizer (missing indexes)
  • Blocking
  • Latch contention

The information captured in the reports is retrieved from SQL Server’s dynamic management views. There is no additional tracing or data capture required, which means the information is always available and this is a very inexpensive means of monitoring your server.

Reporting Services is not required to be installed to use the Performance Dashboard Reports.

Installation

The SQL Server 2012 Performance Dashboard Report can be obtained here. This is a very easy install to perform and can be handled in these steps:

Save the file

 

Click Next

Accept the License

Fill out the Registration Information

Click Next

Click Install

It will provide a status

Click Finish

Configure the SQL Server Management Studio to browse this custom report

You are not quiet done yet with this installation. Please read the readme text file

Open the file location of %ProgramFiles(x86)%\Microsoft SQL Server\110\Tools\Performance Dashboard

Click on Setup.sql

 

Execute the query to build the report

Wait for the message Script completed!

Right-click on Databases, Select Reports, then Custom Reports

Browse to %ProgramFiles(x86)%\Microsoft SQL Server\110\Tools\Performance Dashboard and then Select performance_dashboard_main.rdl

Run Custom Report (Take note of the warning)

Here is your new dashboard

 

Here is where you should click to see a quick overview of your SQL Server

For those who are new to SQL and are not quite ready to query DMV or DMF, looking at wait stats, or gather perfmon counters then this tool can help you get a snapshot of your SQL server. It is a pretty helpful tool and can help most people who are responsible for managing a SQL server.

Tags: , , , , , ,

Comments are closed.

Copy Protected by Chetans WP-Copyprotect.