MS SQL Server - Sysprocesses Open

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Sysprocesses Open_Tran and Blocking

cbrichards via SQLMonster.com

2006-11-09, 7:14 pm

I am having a blocking problem and one area I am considering looking into is
the way the application handles query timeouts. In running sysprocesses, the
SPID at the head of the blocking chain is consistently at 2. I understand
this might be a sign that the application is not handling query timeouts.
However, the Status for this SPID is "runnable". Any suggestions as to
whether this (the application and the way it handles query timeouts) is worth
pursuing, based upon these findings?

--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200611/1

Sponsored Links