Last week I attended the SQL Server Day at Mechelen (Belgium). It was a great event. All the sessions were excellent. One of the sessions was “Reporting Services a DBA’s tool? YES!!!“. During this session I heard about the “SQL Server 2005 Performance Dashboard Reports“. This is a Microsoft addon for SQL Server 2005. SQL Server must have the SP2 already installed in order to use the SQL Server 2005 Performance Dashboard Reports. I found an excellent article from Brad McGehee, with the title “Making the Most Out of the SQL Server 2005 Performance Dashboard“. The article explains how to setup the addon and it also explains how to use the reports. This tool can help you to identify and troubleshoot performance problems. You can download it here.
There are some known issues with the performance dashboard. The first is the “Difference of two datetime values caused an overflow at runtime”. This problem can be solved by following the instructions in http://dylanbeattie.blogspot.com. Sadly enough I have not been able to solve the second known issue, which is “Arithmetic overflow error converting expression to data type datetime”. I found a post which has a possible solution, but I have not test it yet. If you would like to test it anyways click here.