View Single Post
  #2 (permalink)  
Old January 28th, 2011, 07:51 AM
Brent Ozar's Avatar
Brent Ozar Brent Ozar is offline
Wrox Author
Join Date: Feb 2010
Location: Chicago, IL, US
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts

If I understand your post right, you're trying to analyze timeouts? You said "times out", but I think that's what you meant. SQL Server doesn't know about timeouts because they happen on the client side - the app waits too long and gives up.

Ken Henderson has a good post about how timeouts work:
Author: Professional SQL Server 2008 Internals and Troubleshooting