Today I decided to leverage performance dash board report for my SQL Server 2008 R2 instance and SQL 2012 RC 0 Instances.
SQL 2008 R2 RTM
I downloaded the msi file and ran setup.sql under SQL 2008 R2 RTM instance. Straight away I was hit by the error
Msg 207, Level 16, State 1, Procedure usp_Main_GetCPUHistory, Line 6
Invalid column name ‘cpu_ticks_in_ms’.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object ‘usp_Main_GetCPUHistory’, because it does not exist or you do not have permission.
The error is because there is no column ‘cpu_tickets_in_ms’ for the DMV sys.dm_os_sys_info,hence I changed the column name in Setup.sql as ms_ticks.
Rob Carrol has a blog post which talks about the same and you can read it here
Once the column was changed the script ran without any trouble.Report worked as per the expectations.
SQL 2012 RC 0
Same testing was done for SQL 2012 RC 0 and I was amazed by the results.The RDL file worked perfectly for SQL 2012 too after changing the same code for setup.sql as mentioned above.
Here is a quick preview of the report which came straight out of SQL 2012 instance.
Performance Dashboard tool will give you some good amount of information and you can always prepare your own customized reports using builds and use it for better control.
I would like to hear from you,if you have built any of these solutions for your environment.
Thanks for reading.