Microsoft's SQL Server Performance Dashboard for SSRS 2005 is still an excellent bit of kit for checking the status of your SQL Server (Microsoft Download page).
However after finding a slight coding issue when trying to install setup.sql (see Previous Blog), and then another issue when running the code (see Previous Blog). Well another issue occured - yippy:-
An Error has occured during report processing (rsProcessingAborted). Cannot read the next data row for the dataset CPU_UTILIZATION_HISTORY. (rsErrorReadingNextDataRow).
Arithmetic overflow error converting expression to data type int.
Again this is another simple fix.
Either amend the following code in setup.sql or look for the SP [MS_PerfDashboard].[usp_Main_GetCPUHistory] in the msdb database.
The line to change is:-
dateadd(ms, -1 * (@ts_now - [timestamp]), GetDate()) as EventTime,
dateadd(ms, -1 * (@ts_now - [timestamp])/1000, GetDate()) as EventTime,