Have you ever noticed one of your SQL Server instances running unusually slowly?
Have you had difficulty quickly identifying what areas could be affecting its performance?
One of our customer support Escalation Engineers, Keith Elmore, specializes in understanding these types of problems. He has worked with customers all over the world on diagnosing their toughest and most critical performance bottlenecks. Keith has put together a set of Reporting Services reports that will help DBAs diagnose potential performance problems. These reports were designed to leverage the new Custom Reports functionality in SQL Server Management Studio (Service Pack 2).
The SQL Server 2005 Performance Dashboard Reports only use Dynamic Management Views and Catalog Views. They do not poll performance counters from the OS, nor do they store a history of your server’s performance over time. These are very light-weight reports that will help diagnose performance problems as they are occurring.
I encourage you to check them out. Feel free to comment here with your thoughts and questions.
SQL Server 2005 Performance Dashboard Reports:
Paul A. Mestemaker II
Microsoft SQL Server Manageability