BizTalk Terminator tool

When we run the Message box viewer or BizTalk health monitoring tool. then we are able to know about Biztalk database health. To clean up from unwanted and unnecessary data of database for better performance and BizTalk health maintenance. Microsoft provides this great tool named BizTalk Terminator tool.

To get more information about MessageBoxViewer click on below link:

https://vkbiztalk.com/2018/02/15/biztalk-health-monitoring-and-message-box-viewer/

The BizTalk Terminator tool allows the you to easily address common BizTalk issues via SQL, WMI, and PowerShell based tasks provided by the BizTalk team. with additional functionality including the ability to suspend, resume, and terminate in bulk by date range as well as make performance tuning changes. Integration with mbvcleanupscripts.xml from the MessageBox Viewer Utility allows Terminator to quickly resolve issues identified by MBV.

you can download this tool from below link:

https://www.microsoft.com/en-in/download/details.aspx?id=2846

BizTalk Message Box database can grow significantly by accumulating suspended messages, put in place a monitoring mechanism to identify and resolve suspended messages. 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 case you can run the BizTalk Terminator which is a tool provided by Microsoft to address these issues.

When using the Terminator tool in a Production environment, it is mandatory to stop everything (host instances, sql agent)

Terminetor.jpg

terminetor2.jpg

We can select the required option for cleanup.

 

Advertisements

One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s