<div>
Thanks Kaminda for the comments, <br />
can you help me with that processid -2 too.<br />
what does it means?<br />
bcoz in the blocked by column I see that -2 process and <br />
when I check the process column there is no -2 processid.<br />

</div>


Thanks Kaminda for the comments,
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.


<div>
<div class="content wysiwyg-content">
Hi All, <br />
I have a blocking situation on my server and when I check Active Monitor, <br />
many processws are being blocked by Process ID 77<br />
and 77 is being blocked by 51<br />
<br />
and when check for 51, it is being blocked by Process ID -2.<br />
but I didn't see any Process with ID -2 in the list of Process column.<br />
<br />
how to resolve it and this blocking is happening very frequently.<br />
how to resolve it?<br />
Thanks in advance.<br />
&nbsp;
</div>
</div>


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.
 

Blocked by PrcessID -2

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.