Tracking Timeouts

• Gary Billins

  SSC-Addicted

  Points: 454

  More actions

  October 16, 2003 at 12:42 pm

  #162575

  The event Lock-Timeout of section Locks provides minimal information about the specific SQL. How can one use trace to retrieve SQL which have timed out.

  Thanks

• October 20, 2003 at 8:00 am

  This was removed by the editor as SPAM

• joachim.verhagen

  Hall of Fame

  Points: 3560

  More actions

  October 24, 2003 at 6:18 am

  #479442

  The timeout event mentions the spid. Look in the trace for the last statement from that spid.