April 16, 2009 at 1:46 am
Does anyone know if there is a performance dashboard for SQL server 2008 or if it is possible to use Performance Dashboard for SQL Server 2005 on SQL Server 2008? We are using SQL 2008 on a Windows Server 2008.
thanx in advance
/Håkan Winther
Senior Database Developer.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
April 16, 2009 at 2:20 am
You can use the Performance Dashboard 2005 for SQL Server 2008.
Hang Deok Cho.
hyemang@gmail.com
DBA
April 16, 2009 at 2:31 am
You can use the 2005 dashboard, but there are a few problems.
I had a couple of times that a report gave an error the first time I used it, but after a refresh it did work. See also this article about a change in the usp_Main_GetCPUHistory procedure.
[font="Verdana"]Markus Bohse[/font]
April 16, 2009 at 2:33 am
Have you tried it your self?
I installed it in my development environment and as i can see there are some defects in the setup script that creates the functions used by the reports.
/Håkan Winther
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
April 16, 2009 at 2:41 am
MarkusB (4/16/2009)
You can use the 2005 dashboard, but there are a few problems.I had a couple of times that a report gave an error the first time I used it, but after a refresh it did work. See also this article about a change in the usp_Main_GetCPUHistory procedure.
Thank you for your help! It works after modifying the setup.sql script as mentioned in your blog.
/Håkan Winther
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply