Performance Dashboard Reports in SQL Server 2008

While running the Performance Dashboard scripts, we will get the following 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.

To fix it, we need to edit MS_PerfDashboard.usp_Main_GetCPUHistory:

create procedure MS_PerfDashboard.usp_Main_GetCPUHistory

as

begin

declare @ts_now bigint

--select @ts_now = cpu_ticks / convert(float, cpu_ticks_in_ms) from sys.dm_os_sys_info

select @ts_now = cpu_ticks / convert(float, ms_ticks) from sys.dm_os_sys_info

..................