negative spid number

Question

Post reply

negative spid number

curious_sqldba

SSC-Dedicated

Points: 36494
More actions
December 2, 2011 at 9:57 pm

#248947

i see a negative spid (-3) blocking my ssis package execution. I couldnt find much info on this. Any help is appreciated. Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

It is a deferred transaction.

Check this article for more info.

http://sqlskills.com/BLOGS/PAUL/post/Disaster-recovery-101-dealing-with-negative-SPIDS-(-2-and-3).aspx

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 2

thanks..i am not sure why is that happening, but the problem here i am trying to resolve is there is an ETL process which for some reason brings down the database to recovery mode( basically crashes the db with stack dump messages). i have the latest sp on an 2008 R2. Any clue?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

That is different than the -3 spid.

Post the error messages you are getting.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 4

SQLRNNR (12/3/2011)
That is different than the -3 spid.
Post the error messages you are getting.

Spid -3 happens after the crash. I am attaching the stack dump which occurs first and then the db goes into recovery mode. I know MSFT can only interpret the stack dumps just wondering if u have any idea whats gng on here.We did dbcc on the db and one of the tables was corrupted , we fixed it however still the db went in recovery mode. I am running the dbcc check now, most likely another table is corrupt. Trying to find out why is the table getting corrupted.

Thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

If you have a repeatable crash, I recommend you call MS support.

Spid -3 is a symptom, not the problem itself.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 6

GilaMonster (12/3/2011)
If you have a repeatable crash, I recommend you call MS support.
Spid -3 is a symptom, not the problem itself.

Surprisingly it ONLY happens for the database which has to process large amount of data for others it just runs fine. May be i should run a trace and see which point it is failing. Any thoughts on this?