Performance Dashboard error "Difference of two datetime values caused an overflow at runtime"

  Have you tried using SQL Server Performance Dashboard?  We’re using this tool on SQL Server Escalation team with customers to troubleshoot real-time performance problems.  It is a great way to quickly find queries with high-CPU, high-reads, waits, etc.   SQL Server 2005 Performance Dashboard Reports http://www.microsoft.com/downloads/details.aspx?FamilyID=1d3a4a0d-7e0c-4730-8204-e419218c1efc&DisplayLang=en   We discovered a problem with one of the stored procedure when…

2