SPID 0 is blocking some SPID.

Question

Post reply

SPID 0 is blocking some SPID.

LearningDBA

SSCertifiable

Points: 6609
More actions
November 17, 2023 at 3:20 pm

#4329608

This is the 1st time I have seen some sessions blocked by SPID 0. Does anyone know what this zero session is?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
November 25, 2023 at 12:15 pm

This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

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

Site Owners SSC Guru Points: 80330 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

andreas.kreuzberg SSCertifiable Points: 6191 More actions · Answer 2

Hello,

maybe you are able to check the query from SPID 0

DECLARE @sqltext VARBINARY(128)
SELECT @sqltext = sql_handle
FROM sys.sysprocesses
WHERE spid = 0
SELECT TEXT
FROM sys.dm_exec_sql_text(@sqltext)

Good luck,

Best regards,

Andreas

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 3

LearningDBA wrote:

This is the 1st time I have seen some sessions blocked by SPID 0. Does anyone know what this zero session is?

Where are you getting this information from???

SPID 0 in the BlkBy column of sp_who2 and the blocking_session_id of the sys.dm_exec_requests DMV means there is NO BLOCKING on that particular session_id.

Please post the code that you're using to determine blocking so that we can help you clear things up.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)