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
Default

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:

http://blogs.msdn.com/b/khen1234/arc...20/483015.aspx
__________________
---
Author: Professional SQL Server 2008 Internals and Troubleshooting
Blog: BrentOzar.com