I'm using SQL Server Profiler to check some long run query. Somehow I see some entries in SQL Server profiler show StartTime is greater than the EndTime, and the Duration value is obviously overflow.

Why is this happening? Any advice? Thanks in advance.

SQL Profiler ScreenShot

Some Examples

  • On my machine I don't see error during that time, and I don't have access to logon the server so I'm not able to tell if there is error on server side.
    – C Y
    Oct 22, 2018 at 21:56
  • I'm running the Profiler on my local machine against the SQL Server hosted on another machine. Thanks a lot for the information about Extended Events, I'm looking into it.
    – C Y
    Oct 22, 2018 at 22:00
  • What eventclass are these? There is a similar question posted but no answer. But if it is related to timeout this might help. Oct 22, 2018 at 23:52


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.