SQL Server 2008 R2 Performance Dashboard Reports


SQL Server 2008 R2 Performance Dashboard Reports
SQL Server 2008 R2效能儀表板報表


Microsoft® SQL Server® 2012 Performance Dashboard Reports
https://www.microsoft.com/en-us/download/details.aspx?id=29063

Supported Operating System

Windows 7, Windows Server 2008 R2, Windows Server 2008 Service Pack 2, Windows Vista Service Pack 2

    Works with the following SQL Server versions: SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

1.安裝

SQL2008R2PerfDashboard00

SQL2008R2PerfDashboard01

SQL2008R2PerfDashboard02

SQL2008R2PerfDashboard03

SQL2008R2PerfDashboard04

SQL2008R2PerfDashboard05

2.設定

Getting Started With the Performance Dashboard Reports
1. In each SQL Server instance, run the script %ProgramFiles(x86)%\Microsoft SQL Server\110\Tools\Performance Dashboard\setup.sql

SQL2008R2PerfDashboard06

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.

SQL2008R2PerfDashboard07

SQL2008R2PerfDashboard08

 

SQL2008R2PerfDashboard09

3.使用

安裝完成之後,在上一個步驟按下run,就會開啟Performance Dashboard Reports

SQL2008R2PerfDashboard10

 

Comments (1)

  1. Good to see SQL Server 2012 works fine with SQL Server 2008 and R2 too.

Skip to main content