A. Tillman (at*********@yahoo.com) writes:
We are having a really big problem with a zombie process/transaction
that is blocking other processes. When looking at Lock/ProcessID
under Current Activity I see a bunch of processes that are blocked by
process 94 and process 94 is blocked by process -2. I assume -2 is a
zombie that has an open transaction. I cannot find this process to
kill and it seems that this transaction is surviving database
restarts. I know which table is locked up and when I run a select *
from this table it never returns. Does anyone have any ideas as to
how to kill is transaction.
-2? This sounds like locks. The process that held the locks experienced
a fatal problem, and SQL Server were not able to release it locks. I'm
afraid your only option is to restart SQL Server to resolve the condition.
If this condition appears often, you should consider opening a case
with Microsoft support. It is likely that this condition is due to a bug
in SQL Server.
Which version of SQL Server are you running? I have seen negative spids,
but only on SQL 6.5 as I can recall.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp