[INACTIVE BLOG] Connected Thoughts – Thiago Almeida

March 19, 2009

Extending MsgBoxViewer with BizTalk Message Body Tracking Count queries

Filed under: BizTalk — Tags: , , , , , — Thiago Almeida @ 7:47 pm



UPDATE: See this post for an update on the extension file for MsgBoxViewer with the query builder tool


I have recently blogged about some queries I wrote that report on the message body tracking counts that are currently on a system’s BizTalk Server Tracking database (BizTalkDTADb usually).

The tracking service (TDDS) monitors the message box database(s) for message details and message bodies that have been marked to be tracked, and moves them to the tracking database. It is very important to consider and test the amount of tracking enabled on your BizTalk solution so that, while still meeting your business requirements,  it doesn’t affect performance and doesn’t grow the tracking database to an unmanageable size. Therefore it is important to have an overview of the message body tracking on a system while analysing it.

The Message Box Viewer tool is extensible so you can include your own custom queries. This is done by creating a file called MBVEXT.XML and placing it on the same folder as the message box viewer GUI executable (MsgBoxViewer.exe) or the console executable (BtsDbCollect.exe):

image  image

This was brought to my attention by Jean-Pierre Auconie, the creator of the tool, who provided me with the content of the MBVEXT.XML file with my Message Body Tracking Count queries (thanks JP!).

Download the MBVEXT.XML file.

In the GUI the new queries appear under the Queries tab, Custom Queries sub-tabs:


And after the collect on the GUI or console, the results of the queries now show up at the end of the queries:


Keep an eye out for an upcoming blog post by Jean-Pierre that explains the extensibility of the tool in further detail, and in the meantime feel free to use this MVBEXT.XML with the tracking body queries. If you do please let me know if you have any comments.

Of course, make sure to be very careful with the queries you add to the tool and test them extensively before running them on any production environment.

Have fun!


UPDATE: See this post for an update on the extension file for MsgBoxViewer with the query builder tool


Thiago Almeida

Create a free website or blog at WordPress.com.


Get every new post delivered to your Inbox.

Join 43 other followers