반응형
SQL Server 2005 Performance Dashboard Reports
http://www.microsoft.com/downloads/details.aspx?FamilyId=1D3A4A0D-7E0C-4730-8204-E419218C1EFC&displaylang=en
1. SQL Server 2005 Performance Dashboard Reports 다운받고 설치
2. '..Microsoft SQL Server\90\Tools\PerformanceDashboard\setup.sql' 실행
3. SQL Management Studio 실행후 해당 DB 나 테이블등을 선택하고 [보고서 => 사용자지정 보고서] 선택
4. '..Microsoft SQL Server\90\Tools\PerformanceDashboard\performance_dashboard_main.rdl' 선택
5. 보고서가 나타난다. 링크를 통해 세부 보고서를 볼수 있다.
System Requirements
- Supported Operating Systems: Windows Server 2003; Windows Vista; Windows XP
- SQL Server 2005 Service Pack 2 or later
Overview
The SQL Server 2005 Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature introduced in the SP2 release 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. For example, if the system is experiencing waits for disk IO the dashboard allows the user to quickly see which sessions are performing the most IO, what query is running on each session and the query plan for each statement.
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.
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.
Instructions
Click the Download button on this page to start the download.
Do one of the following:
1. To start the installation immediately, click Open or Run this program from its current location.
2. To copy the download to your computer for installation at a later time, click Save or Save this program to disk.
Do one of the following:
1. To start the installation immediately, click Open or Run this program from its current location.
2. To copy the download to your computer for installation at a later time, click Save or Save this program to disk.
Additional Information
The SQL Server instance being monitored must be running SP2 or later. After completing the installation, you must:
1. Run the Setup.sql file on each instance of SQL Server 2005 that you wish to monitor with the SQL Server 2005 Performance Dashboard Reports.
2. Open the performance_dashboard_main.rdl file with the Custom Reports functionality new to Management Studio in Service Pack 2.
1. Run the Setup.sql file on each instance of SQL Server 2005 that you wish to monitor with the SQL Server 2005 Performance Dashboard Reports.
2. Open the performance_dashboard_main.rdl file with the Custom Reports functionality new to Management Studio in Service Pack 2.
반응형