Solved

Curious Case of -ve Spid

Posted on 2012-03-28
2
577 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
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
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.
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

932 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now