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.
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)
- 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.
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
Accept the License
Fill out the Registration Information
It will provide a status
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.