Hi All,

Today we faced the issues with the Host instances as these are in hung state, all the messages are piled up and are unable to process.

If host instances are in hung mode, first try to restart the host instances, if it is not happening, check the msgbox blockings.

If blockings are there, check who is causing those blockings?

Sp_who2 active for checking the blockings in BizTalkMsgBoxDb

We have issue like Sql agent job is failing at our end

MessageBox_Parts_Cleanup_BizTalkMsgBoxDb Job is failing at our end which needs to run at every one minute.

select count(*) from BizTalkMsgBoxDb..Spool (nolock)

that’s why we have huge number of messages piled up in the above table Of message box

Issue is above job is holding the lock on the message box tables and host instances are requesting the lock on those same tables and it is causing the blocking.

We have killed the blocking and job became successful and issue got fixed.

Regards,

Visit site: http://www.sqlblogging.com

Send an Email: sqlblogging