SQL Server Performance

Spurious errors when using SQL Server 2005 Performance Dashboard Reports

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 16, 2007.

  1. Anonymous New Member

    You might have observed errors when using Performance Dashboard reports that is available (recently) for SQL Server 2005, the error below is mostly ocurred: Difference of two datetime columns caused overflow at runtime. Based on the forums &amp; other blogs on the web suggests that The fix for that error is to update setup.sql file residing into Performance Dashboard folder: C:program FilesMicrosoft SQL Server90ToolsPerformanceDashboard by editing search in script " procedure MS_PerfDashboard.usp_Main_GetSessionInfo...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2007/08/16/1510.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1510" width="1" height="1">

Share This Page