Friday, August 1, 2008

Analyze SQL Server Performance Graphically

SQL Server 2005 Performance Dashboard utility will alow you to have a comprehensive glance of Server performance. If you are not familiar with DMVs to sort out performance bottelnecks this tool is for you. But don't forget learning and interpreting the output of DMVs will give you the most accurate and detailed analysis.
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.
Click the link below to download it from Microsoft website.
System Requirements
Supported Operating Systems: Windows Server 2003; Windows Vista; Windows XP
SQL Server 2005 Service Pack 2 or later
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.
Also you can read the PerfDash.chm that is located in the installation directory.
Have fun!

1 comment:

  1. Hi here i wanna add 1 more thing pssdiag tool for performance tunning and server tunning.

    ReplyDelete