Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
up vote 4 down vote accepted

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

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

share|improve this answer
It's not a custom report and I did try re-running the setup script. I read somewhere there was a 24 day limit to some reports due to a int overflow when doing date math. Now I can't find where I read it. – Mike L Jun 18 '09 at 18:10
There's a fix for that error on this blog which mentions the 24 day limit… – Chris W Jun 19 '09 at 8:33
That did it. Thanks! – Mike L Jun 19 '09 at 14:29

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,

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.