BizTalk Server Tip #24: Maintain you Message Box efficiently

February 26, 2014

tip24

Don’t let your BizTalk Message Box database grow significantly by accumulating suspended messages, put in place a monitoring mechanism to identify and resolve suspended messages as soon as possible. When you find a database integrity problem that is causing your databases to grow use the BizTalk Terminator to resolve this.

Maintaining the health of your BizTalk databases is vital for any BizTalk environment, specially when we are talking about the BizTalkMsgBoxDb, there are several reasons for the databases to grow like suspended messages that you should avoid and resolved quickly when they happen. You can also have some integrity problems identified by using the out of the box Monitor Job or by running a tool like the Message Box Viewer, in this cases you can run the BizTalk Terminator which is a tool provided by Microsoft to address these issues.

Read about the BizTalk Terminator

blog-action04_thumb2333333333333333[3][3][3]

Author: Ricardo Torre

Head of Technical Pre-Sales & Product Strategist at BizTalk360, an enterprise software that acts as an all-in-one solution for better administration, operation, support and monitoring of Microsoft BizTalk Server environments.

  • Vulturius

    When using the Terminator tool in a PRD, it is mandatory to stop everything (hostinstances, sql agent, …)
    In a 24/7 env. we cannot stop and start as we please … cleaning up the MsgBox becomes hard. Is it really necessary to stop all on BizTalk to clean suspended msgs, … ?

    • saravanamv

      It will be difficult for an external tool like Terminator to understand all the dependencies, so the safe bet for them is to ask to stop all host instances.

Get full control of your BizTalk Environments

Over 500 customers across 30+ countries depend on BizTalk360

Start your 14 days Free Trial

Back to Top