Chris Straw
SHARE:

Count of Suspended Messages in BizTalk

This SQL Script will give you the count of all suspended messages in BizTalk. Run this against the BizTalkMsgBoxDb.

set nocount on
set transaction isolation level read COMMITTED
set deadlock_priority LOW

SELECT COUNT(*) 
FROM InstancesSuspended WITH (NOLOCK)