I have a Windows server 2003 which has Biztalk Server 2006 enterprise Edition and SQL server 2005 on it.
I have had messages like process blocked by -2 in SQL server logs on the same server. I tried killing that process but blocking comes back after some time.
I have applied the following hotfixes after someone suggested:
FIX: Orphaned cache instances may be built in the Instances and Hosts Queue tables of the BizTalkMsgBoxDb database in BizTalk Server 2006 and in BizTalk Server 2006 R2 KB944426
FIX: Routing failure reports are not removed from the Q_Suspended table on a BizTalk Server 2006 server http://support.microsoft.com/kb/941690/en-us on it.
This seemed to solve the problem for some time. But I have been seeing these "blocked by -2" message in SQL server logs lately.
Any ideas what I should do now?