Welcome to MSDN Blogs Sign in | Join | Help

September 2009 - Posts

Troubleshooting Arithmetic overflow errors in queries using Extended Events in SQL Server 2008

Problem: Management view sys.dm_exec_requests has a column total_elapsed_time to track the total time elapsed in milliseconds since the request arrived. Following T-SQL query converted this value from milli-seconds to micro-seconds. -- Simplified version
 
Page view tracker