asked on
Blocked by PrcessID -2
Hi All,
I have a blocking situation on my server and when I check Active Monitor,
many processws are being blocked by Process ID 77
and 77 is being blocked by 51
and when check for 51, it is being blocked by Process ID -2.
but I didn't see any Process with ID -2 in the list of Process column.
how to resolve it and this blocking is happening very frequently.
how to resolve it?
Thanks in advance.
I have a blocking situation on my server and when I check Active Monitor,
many processws are being blocked by Process ID 77
and 77 is being blocked by 51
and when check for 51, it is being blocked by Process ID -2.
but I didn't see any Process with ID -2 in the list of Process column.
how to resolve it and this blocking is happening very frequently.
how to resolve it?
Thanks in advance.
Microsoft SQL Server
Last Comment
msdba
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks
can you help me with that processid -2 too.
what does it means?
bcoz in the blocked by column I see that -2 process and
when I check the process column there is no -2 processid.