April 2009 - Posts

Performance Dashboard Reports for SQL Server 2008

Recently, I learned from a colleague that it's possible to run the SQL Server 2005 Performance Dashboard reports on SQL Server 2008, with a couple of slight modifications. There is a great new feature in SQL Server 2008 called Performance Data Collection, which I have blogged about in the past, and this is excellent for tracking SQL Server performance over time across your 2008 estate. There is also the excellent revamped Activity Monitor in SQL 2008. However, if you want to continue to use the Performance Dashboard reports, which many DBA's have found invaluable, they are not supported in SQL Server 2008.

To learn how to configure these reports to run on SQL Server 2008, click here for more information.



Rob Carrol, SQL Server PFE, Microsoft UK



This Blog