Thursday, July 19, 2012

Best Practices of Microsoft® SQL Server® 2012 Performance Dashboard Reports



For Monitoring real time SQL Server Performance, Use Performance Dashboard Reports

For this,Download from this link

http://www.microsoft.com/en-in/download/confirmation.aspx?id=29063

1.Click to install the SQLServer2012_PerformanceDashboard.msi






























 


 Read the README.txt file

Getting Started With the Performance Dashboard Reports


1. Each SQL Server instance you plan to monitor must contain the procedures and functions used by the queries in the reports.  Using SQL Server Management Studio (SSMS), open the setup.sql script from your installation directory (default of %ProgramFiles(x86)%\Microsoft SQL Server\110\Tools\Performance Dashboard) and run the script.  Close the query window once it completes.

2. In the Object Explorer pane in SSMS, right mouse click on the SQL Server instance node, then choose Reports-Custom Reports.  Browse to the installation directory and open the performance_dashboard_main.rdl file.  Explore the health of your server by clicking on the various charts and hyperlinks in the report.


All of the remaining reports are accessed as drill through operations from the main page or one of its children.  For a detailed explanation of all installation requirements and guidance on how to use the reports, please see the help file, PerformanceDashboardHelp.chm.



2.Connect SQL Server 2008 R2 Database.


Use standard reports to monitor SQL Server 





3.Go %ProgramFiles(x86)%\Microsoft SQL Server\110\Tools\Performance Dashboard

Execute the setup.sql for generating custom report.

4.Add Performance Monitor Main Report.



Sample report shown for sql server.