How to Fix Performance Dashboards for SQL 2008

The SQL 2005 Performance dashboard is a fantastic way to gain access to SQL’s dynamic management views (DMVs) without the need for lengthy SQL queries. Bringing this across into SQL 2008 however requires a little more attention however.

Below is the Microsoft Article for fixing up Performance Dashboard (2005) so that it works properly for SQL 2008: http://blogs.technet.com/b/rob/archive/2009/02/18/performance-dashboard-reports-for-sql-server-2008.aspx