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 an...