Celtic Coding Solutions Blog

Celtic Coding Solutions Blog - for everything computer related

Microsoft Performance Dashboard for SQL Server 2008 - Issue 3

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.  unwanted pregnancy Either amend the following code in setup.sql or look for free abortions 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,

to

dateadd(ms, -1 * (@ts_now - [timestamp])/1000, GetDate()) as EventTime,

Comments are closed