Microsoft's SQL Server Performance Dashboard for SSRS 2005 is still an excellent bit of Microsoft Download page).
kit for checking the status of your SQL Server (
However after finding a slight coding issue when trying to install setup.sql see Previous Blog I have now found another issue when running the code:-
An Error has occured during report processing. (rsProcessingAborted). Cannot read the next data row for the dataset SESSION_CPU_WAIT_INFO (rsErrorReadingNextDataRow)
The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.
Again this is a simple fix. Either amend the following code in setup.sql or look for the SP [MS_PerfDashboard].[usp_Main_GetSessionInfo] in the msdb database.
The line to change is:-
sum(convert(bigint, datediff(ms, login_time, getdate()))) - sum(convert(bigint, s.total_elapsed_time)) as idle_connection_time,
sum(convert(bigint, CAST( DATEDIFF(minute, login_time, getdate()) as bigint)*60000
+DATEDIFF(millisecond, DATEADD(minute, DATEDIFF(minute, login_time, getdate()), login_time), getdate() )))
-SUM(CONVERT(bigint, s.total_elapsed_time)) as idle_connection_time,