0

Count of Suspended Messages in BizTalk

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

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)

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.