June 24, 2015 at 10:52 am
I got a situation where all of a sudden SPID are being blocked by a SPID of -1.
Any ides on how to resolve the process?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 24, 2015 at 4:50 pm
The SPID's with a -1 have about 20 entries for the same DPID.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 25, 2015 at 3:18 am
SPID -1 is quite odd. It seems an orphaned transaction lock or something similar. Can you try to use the same workaround like SPID -2 issues?
http://www.mytechmantra.com/LearnSQLServer/Kill-Negative-SPID-in-SQL-Server/%5B/url%5D
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply