Welcome to TechNet Blogs Sign in | Join | Help

My Biztalk Tools blog

MsgboxViewer blog
BizTalk MsgBoxViewer - download here the latest version of the tool

Version 9.24 

Download it : MsgBoxViewer9_24.zip

 

New Features :

- Both Gui and Console versions use now a settings file named resepectively "MsgBoxViewer_Settings.xml" and "Btsdbcollect_settings.xml" to store tool options and optional queries selected :

* This file is created/updated when the tool exits and loaded at tool startup if  found
* Any options passed as arguments to the Console version will overlap the ones stored in the settings file

* Console version  generates a settings xml file if no present already in the tool's folder but it will NOT update existing one at exit as the Gui version does.

* If you use the Console version, you can so update manually "btsdbcollect_settings.xml" config file to select only the optional queries you want to keep executed for example

- Add "Last 100 Recent Svc instances" optional query (original query of HAT)

- Log now in HTML and History files the title of ALL queries available in the tool but gray out the unselected or disabled  ones.
  We can see quickly so which query was unselected or disabled because of role missing

- XML Summary Report section was modified to be used easely in future parsing tools


Changes/Fixes :

 

- Table size order for DTA and MsgBox databses is now done in DESCENDING mode so the largest table will be the first one in the report if this order choice is selected (by default).

- First 4 DTA optional queries are now unselected by default to accelerate Collect proces 

Version 9.23.5 

Download it : MsgBoxViewer9_23_5.zip


New Features :

 

- Change format of the SUMMARY REPORT section. Now this report is composed of 3 sub-reports :

 

    * "Critical Warnings" : report only the red warnings - this report is always expanded by default
    * "Non Critical Warnings" : report only the yellow warnings - this report is collapsed by default
    * "Full Summary Report : represent the complete Summary Report - this report is collapsed by default

 

- Add the total Collect Duration at the begining of the Full Summary Report

 

 

Version 9.23.42

Download it : MsgBoxViewer9_23_42.zip


New Features :

 

- Get high fragmentation info for MsgBox and DTA DBs
  Note:  this SQL query can be long to execute and so the default query timeout of 30s can expire but it can be changed in both the Gui  and Console  tools.

- Retrieve now also dynamic send ports in the Send ports detailed report

- Included TwoWay  settings in Send Ports and Receive Locations Detailed Reports (for their port)

- Include now the RulesEngine Db in the list of databases checked

- Add hyperlinks to the Summary Report Categories  in the Summary Report header


Fixes:

 

- Decreased the severity of "Time Difference" warning from red to yellow and improved statements to get the time of each server to avoid if possible to have false alarm on that.
Now I raise a warning if the time difference between a BTS box and SQL box hosting a MsgBox db is >=2 minutes.

 

- Fixed an issue when reading the db schema version  in btsdbversion table of each BizTalk Db. Until now only the first record was read and starting with this build I enumerate all possible records in this table and take in account the most recent db schema version found

 

 

 

Version 9.23.4

 


Change:

 

- Keep only the name of Stored Procs in the  "Most CPU Queries (SQL 2K5 only)" instead of the entire sp text

Posted: Tuesday, December 18, 2007 9:49 PM by jpierauc
Filed under:

Attachment(s): MsgBoxViewer9_24.zip

Comments

Jean-Paul Smit said:

On a blogpost by Yossi Dahan I read about a BizTalk tool I didn't know about: MsgBoxViewer Via Google

# May 6, 2008 7:55 AM

EAI world! said:

Cuando necesitamos conocer y/o predecir del comportamiento de nuestro entorno de BizTalk Server entonces,

# May 27, 2008 1:52 PM

Mike said:

Hello JP,

When running the BizTalk MsgBoxViewer, it is dropping and creating the objects sp_who3 and fn_MapWaitResource every time that it runs. Would it be possible to modify the tool to only create the objects if they don't exist? Our DBA group is comfortable giving our support group execute permissions on these objects but not the permission to drop or create objects in the master DB.

Thanks,

Mike

# May 29, 2008 10:46 AM

JP said:

Hi Mike,

your remark make sens but I remember that I already tried this initally and I met some errors;but let me some time this week to investigate that; I already had this remark before and I understand the need.

FYI, this script is comming directly from known Biztalk architect Lee Graber; he reused known 'sp_who' that he modified to help our suport teams to troubleshoot BizTalk Locking situations in the MsgBox.

JP

# May 29, 2008 3:12 PM

Jukka said:

It would be nice if the viewer would report Biztalk Application for each artifact. Even better if the artifacts could be grouped under Applications.

We have a BTS group with tens of Applications and hundreds of ports and orchestrations. We are planning a migration to a HA environment and need to analyze/report which adapters and hosts an application needs.

# June 11, 2008 10:45 AM

jpierauc said:

Hi Jukka,

Thanks for this sugestion but I just would like to understand it better, as currently in the BizTalk Console of BizTak 2006 you can see in the "Resources" node all assembly resources per Application.

Is it what you want or do you want to have a larger view not specific to assemblies ?

thanks

JP

# June 11, 2008 11:35 AM

Manuel Stern said:

Hi JP

In the section "Most CPU Queries (SQL 2K5 only)", MBV shows the entire sp text.

This makes it quite cumbersome to read.

Could you show only the names of the sprocs?

Thanks,

Manuel

# July 2, 2008 6:01 AM

jpierauc said:

humm..very good suggestion Manuel !

it makes so sense that I wonder why I did not do that before !?  it reduce indeed significantly size of output HTML file, History.Log, and XML file (if this option was selected)

I changed that so and uploaded a new  build (9.23.4) :

http://blogs.technet.com/jpierauc/pages/msgboxviewer.aspx

JP

# July 2, 2008 9:40 AM

Atin Agarwal's Blog said:

I have seen most of the issues coming with slow processing of messages in production by Biztalk where

# July 14, 2008 10:58 AM

ламинат said:

w Een plaatje zegt alles, toch ? t  Het volledige rapport is hier te vinden. Lees natuurlijk r  de blogposting. t a

[url=http://skuper.ru]ламинат купить [/url] 4u

# August 12, 2008 1:01 AM

ламинат said:

xik Een plaatje zegt alles, toch ? uzz  Het volledige rapport is hier te vinden. Lees natuurlijk m  de blogposting. t n

Thanks for interesting post! lsj

[url=http://skuper.ru]ламинированный парке[/url] 1d

# August 13, 2008 4:58 AM
Leave a Comment

(required) 

(required) 

(optional)

(required) 

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Page view tracker