Home Forums Article Discussions Article Discussions by Author Discuss content posted by Robert Griffin SQL Server 2005 Performance Dashboard Using SSRS RE: SQL Server 2005 Performance Dashboard Using SSRS

  • June 17, 2010 at 6:26 am

    #1181503

    sibir1us (7/28/2009)

    If you would like to use the Performance Dashboard 2005 on SQL Server 2008 you will have to make the following change in the usp_Main_GetSessionInfo stored procedure.

    Change the line:

    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,

    I ran into to this problem, "Difference of two datetime columns caused overflow at runtime" on sql2005 today for the first time. Your code above worked....Thanks! I just wonder what changed to cause it to start happening....????