[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:

image

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

image

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

About these ads

4 Comments

  1. Hi Thiago

    Good stuff… would you pls mind sharing the latest version of the original MVBEXT.xml file that comes with MBV from jearn-Pierre?
    I want to see the queries running behind the scene. I have another application which uses these queries to report to a monitoring system

    Thanks
    Firoz

    Comment by FirozOzman — April 9, 2009 @ 7:30 am

    • Hi Firoz,

      The queries that come with MBV are built into it and aren’t part of an extension file. You use the MVBEXT.xml to add your custom queries to it.
      You can get the SQL queries from it by running SQL Server Profiler while MBV is collecting, or you can try contacting JP on his blog ( http://blogs.technet.com/jpierauc/ ).

      Cheers,
      Thiago

      Comment by Thiago Almeida — April 9, 2009 @ 8:35 am

  2. [...] called the Message Box Viewer Query Builder. JP has also posted a quick help about the tool. On a previous post I went over how to extend the message box viewer tool version 10 with your own custom queries and [...]

    Pingback by MBVQueryBuilder and BizTalk Message Body Tracking Count queries « Connected Thoughts - Thiago Almeida — April 30, 2009 @ 11:46 am

  3. Hi,

    I download the mbvext.xml, put it in the same directory than mbvgui.exe
    but when i launch it , i didn’t see the subtab custom query.
    can you help me please?
    thanks

    Comment by didi — March 5, 2010 @ 9:32 pm


RSS feed for comments on this post.

Sorry, the comment form is closed at this time.

The WordPress Classic Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 39 other followers

%d bloggers like this: