0

Count of Active or Started Messages in BizTalk.

Posted by Chris Straw on November 27, 2011 in BizTalk, SQL Server |

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'

Tags: ,

Leave a Reply

Your email address will not be published. Required fields are marked *

Copyright © 2011-2019 Chris Straw All rights reserved.
This site is using the Desk Mess Mirrored theme, v2.5, from BuyNowShop.com.