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

FROM InstancesSuspended WITH (NOLOCK)

Tags: ,

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

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