BizTalk Server Tip #24: Maintain you Message Box efficiently

|  Posted: February 26, 2014  |  Categories: BizTalk Server BizTalk360

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.

One Platform Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

ServiceBus360

Azure service bus

Learn more

Start managing your Azure Service Bus namespaces in minutes

One Platform - Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

One Platform - Operations, Monitoring and Analytics Software
ServiceBus360

Azure service bus

Learn more

Start managing your Azure Service Bus namespaces in minutes

Back to Top