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
