SQL Server 2005 Performance Dashboard Reports


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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s