Celtic Coding Solutions Blog

Celtic Coding Solutions Blog - for everything computer related

Microsoft Performance Dashboard for SQL Server 2008 - Issue 2

Microsoft's SQL Server Performance Dashboard for SSRS 2005 is still an excellent bit of medication abortion 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 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 anti abortion facts 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,

to

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,

Comments are closed