Chris Straw
SHARE:

Count of Active or Started Messages in BizTalk.

November 27, 2011 by Chris Straw

This script will give you a count of active messages within BizTalk. This includes currently processing messages, as well as suspended resumable messages. Run this against the BizTalkDTADb.

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

SELECT COUNT(*) 
FROM dbo.dtav_ServiceFacts 
WHERE [ServiceInstance/State] = 'Started'

Written by

Chris Straw