22 October 2009 19:02
tonyrogerson
SQL Server 2005 Support - Performance Dashboard using Management Studio Custom Reports - the download
There is so much out in the cosmos for helping with the manageability of SQL Server, this particular download from Microsoft is the early concept that later became the Management Data Warehouse in SQL Server 2008 which frankly is way cool.
Anyway - this really cool download helps you find bad queries, check waitstats, anyway - here is the overview from the download page....
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
Remember its SP2 of SQL Server 2005 you need.
Filed under: SQL Server, Support, Management Data Warehouse