Solved

Curious Case of -ve Spid

Posted on 2012-03-28
2
585 Views
Last Modified: 2012-08-13
Hello experts,
          Today because of lack of space, one of the database went to offline. I tried bringing the database online:

alter database <dbname> set online

          But I saw something unusual. The spid (mine was working with spid = 80) got blocked by a -ve spid,  "-3". sp_who2 doesn't even allow me to see what is running, but when I check my spid with sp_who2 80, it was being blocked by -3. On googling, I got information about -2 but it looks like a standard one. Not a single discussion was there on other -ve spids. It didn't allowed to me to kill -3. Based on the following link, I tried getting the req_transactionUOW, but with no lock it was all 0000000000's... So, couldn't have a hand on req_transactionUOW to kill the spid. I don't want to restart the server as a general fix but want to analyze as much as possible. Can someone help me out?
http://www.sqlserverclub.com/articles/how-to-deal-with-negative-spids-in-sql-server.aspx
0
Comment
Question by:TempDBA
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 9

Accepted Solution

by:
rajeevnandanmishra earned 500 total points
ID: 37776939
May be this link will guide you:

Negative SPIDs
0
 
LVL 25

Author Closing Comment

by:TempDBA
ID: 37777776
This doesn't solve the problem but gave a good insight on it. Thanks a lot.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question