Count of Suspended Messages in BizTalk

November 27, 2011 by Chris Straw

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)

Chris Straw