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:http://www.microsoft.com/downloads/details.aspx?FamilyId=1D3A4A0D-7E0C-4730-8204-E419218C1EFC&displaylang=en
Paul A. Mestemaker IIProgram ManagerMicrosoft SQL Server Manageability
Microsoft SQL Server 2005 Performance Dashboard Reports предназначен для контроля и получения необходимой
I have same error after click on Blue part of System CPU Utilization graph on dash board. Please help as I have used given suggestion here and it didn't worked.
Thanks in Advance.
Thank you David for the fix - also helped my problem.
These reports immediately gave me a datetime error, as others have described. A pity MS have not fixed the bug even all these years later.