Home / server / Questions / 28082
Accepted
Mike L
Asked: 2009-06-19 07:26:31 +0800 CST

How do you fix the Performance Dashboard datetime overfow error

  • 772

I'm a programmer/DBA by accident and we're running SQL Server 2005 with Performance Dashboard for basic monitoring. The server has been up for a few weeks and now we can't drill into certain reports. Is there any way to reset these reports without a complete reboot?

edit: I bet the error message would help.

I get this when I drill into the CPU graph: Error: Difference of two datetime columns caused overflow at runtime.

sql-server sql-server-2005 performance-monitoring

2 Answers

  1. Best Answer

    What are the errors your getting?

    Have you tried re-running the dashboard set-up script?

    One approach you could try is to close SSMS and then delete reports.xml from %userprofile%\Application Data\microsoft\Microsoft SQL Server\90\Tools\Shell which clears your custom report data I think - see http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/780bac33-663a-4532-a23c-fb10564cb328

    Then make sure that it's the performance_dashboard_main that you open - the other reports are accessed from it.

    • 4

  2. go to system database >> msdb >> programmability >> Stored procedure >> usp_Main_GetSessionInfo

    sum(convert(bigint, datediff(ms, login_time, getdate()))) - sum(convert(bigint,s.total_elapsed_time)) as idle_connection_time,

    replace above by below

    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,

    • 1