Solved

Curious Case of -ve Spid

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

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Add a step to a system backup job 6 55
SQL server client app 3 76
Need to create and populate a column map table 5 62
Classic ASP - Display returned sql output parameter 9 57
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

738 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