Hello BizTalk community,
I continued to work on MBV since its recent version 13, improving its UI and updating again its repository (queries and rules).
I also fixed some issues that were reported to me and I added some interesting features :
1) MBV provides now a new section named “Dashboard report”.
This section contains in fact all indicators considered as critical for the good health of a BizTalk group and will allow you to have a very quick view of the state of your BizTalk System.
This view was missing from my experience spent with some BT admins; indeed, the existing “Summary Report” section contains already lot of important information but we don’t know obviously what is crucial to monitor among that volume of information and what is reflecting the good health of a BT System.
This Dashboard section takes so only some important entries of the Summary Report and isolate them in a specific section.
Idealy I would appreciate to have also a such view in one tab of the Hub page of the BizTalk console, showing quickly the number of total messages in all MsgBox queues, the used space of the BizTalk databases, the state of the jobs,etc… 😉
This is a sample view of that section :
Dashboard Report
| Item Caption | Item Value |
| BizTalk Databases – Sizes | |
| Total DB Space Used for MGMT DB “BizTalkMgmtDb” on MJPAUCLT | 12.00 MB |
| Total DB Space Used for MSGBOX DB 1 (MASTER) “BizTalkMsgBoxDb” on MJPAUCLT | 8.84 MB |
| Total DB Space Used for DTA DB “BizTalkDTADb” on MJPAUCLT | 7.66 MB |
| Total DB Space Used for BAM PRIMARY IMPORT DB “BAMPrimaryImport” on MJPAUCLT | 6.69 MB |
| Total DB Space Used for RULEENGINE DB “BizTalkRuleEngineDb” on MJPAUCLT | 3.22 MB |
| Total DB Space Used for SSO DB “SSODB” on MJPAUCLT | 5.67 MB |
| BizTalk Host Instances | |
| Total Host Instances | 2 |
| Total Host Instances Running | 1 |
| Total Tracking Host Instances Running | 1 |
| MJPAUCLT: BizTalkServerApplication (PID:4524.000) | Memory = 73863170.000 bytes, Thread Count = 76.000 |
| Ports, Pipelines & Orchs | |
| Total Receive Locations | 3 |
| Receive Locations disabled | 2 |
| Total Send Ports | 2 |
| Send Ports stopped | 0 |
| Total Orchestrations Deployed | 4 |
| Orchestrations stopped | 0 |
| BizTalk Jobs | |
| Backup BizTalk Server (BizTalkMgmtDb) | State=Disabled,Sched=15m,No History Found |
| CleanupBTFExpiredEntriesJob_BizTalkMgmtDb | State=Enabled,Sched=12h,Last Status=Succeeded,Last Duration (hhmmss)=000000 |
| DTA Purge and Archive (BizTalkDTADb) | State=Disabled,Sched=1m,No History Found |
| MessageBox_DeadProcesses_Cleanup_BizTalkMsgBoxDb | State=Enabled,Sched=1m,Last Status=Succeeded,Last Duration (hhmmss)=000000 |
| MessageBox_Parts_Cleanup_BizTalkMsgBoxDb | State=Enabled,Sched=1m,Last Status=Succeeded,Last Duration (hhmmss)=000000 |
| MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb | State=Enabled,Not Running,Sched=1m |
| MessageBox_Message_Cleanup_BizTalkMsgBoxDb | State=Disabled,Last Status=Succeeded,Last Duration (hhmmss)=000000 |
| PurgeSubscriptionsJob_BizTalkMsgBoxDb | State=Enabled,Sched=1m,Last Status=Succeeded,Last Duration (hhmmss)=000000 |
| TrackedMessages_Copy_BizTalkMsgBoxDb | State=Enabled,Sched=1m,Last Status=Succeeded,Last Duration (hhmmss)=000000 |
| MessageBox_UpdateStats_BizTalkMsgBoxDb | State=Enabled,Sched=5m,Last Status=Succeeded,Last Duration (hhmmss)=000001 |
| Operations_OperateOnInstances_OnMaster_BizTalkMsgBoxDb | State=Enabled,Sched=1m,Last Status=Succeeded,Last Duration (hhmmss)=000000 |
| Longer job’s duration (except ‘Message_ManageRefCountLog’) | 000001 Sec (MessageBox_UpdateStats_BizTalkMsgBoxDb) |
| DTA Tables | |
| Larger table | “dta_Services” – 1016 KB -59 Rows |
| MsgBox Tables | |
| Larger table – MSGBOX DB 1 (MASTER) “BizTalkMsgBoxDb” on MJPAUCLT | “Fragments” – 1064 KB – 33 Rows |
| Total in MsgBox TrackingData table(s) – MSGBOX DB 1 (MASTER) “BizTalkMsgBoxDb” on MJPAUCLT | 96 KB – 0 Rows |
| Total in Tracking Body tables – MSGBOX DB 1 (MASTER) “BizTalkMsgBoxDb” on MJPAUCLT | 0 KB – 0 Rows |
| Total in Q tables (Work + Suspended) – MSGBOX DB 1 (MASTER) “BizTalkMsgBoxDb” on MJPAUCLT | 112 KB – 10 Rows |
| MsgBox Queues | |
| Total Suspended Messages – MSGBOX DB 1 (MASTER) “BizTalkMsgBoxDb” on MJPAUCLT | 10 |
| Total Suspended Resumables Messages – MSGBOX DB 1 (MASTER) “BizTalkMsgBoxDb” on MJPAUCLT | 10 |
| Total Pending Messages in Work Q – MSGBOX DB 1 (MASTER) “BizTalkMsgBoxDb” on MJPAUCLT | 0 |
| “BizTalkServerApplicationQ_Suspended” has most Suspended Messages | 10 |
| MsgBox Database Integrity | |
| Message Refs w/out Spool rows | 0 |
| Messages w/out RefCounts | 0 |
| Message Refs w/out Instances | 0 |
| Subscriptions w/out Instances | 0 |
| InstanceState w/out Instances | 0 |
| Messages with RefCount = -1 | 0 |
| Messages processed | |
| Today | Sent = 0, Received = 0 |
| Service Instances | |
| Ready To Run – MSGBOX DB 1 (MASTER) “BizTalkMsgBoxDb” on MJPAUCLT | 0 |
| Active – MSGBOX DB 1 (MASTER) “BizTalkMsgBoxDb” on MJPAUCLT | 1 |
| Suspended Non-Resumable – MSGBOX DB 1 (MASTER) “BizTalkMsgBoxDb” on MJPAUCLT | 5 |
| Suspended Resumable – MSGBOX DB 1 (MASTER) “BizTalkMsgBoxDb” on MJPAUCLT | 5 |
| Dehydrated – MSGBOX DB 1 (MASTER) “BizTalkMsgBoxDb” on MJPAUCLT | 0 |
2) I also changed a little bit the size and orientation of the frames of the generated HTML files to clarify again the output.
This is a sample of the new output :
3) I added finally the possibility to change more quickly the current profile in both UI and console version of MBV and added some two predefined profiles “Minimum” and “Full”.
I recall that a profile stores the selected queries, the query custom properties, and all the MBV global options, and each profile is stored in a file prefixed by “MBVSettings_”.
At MBV UI startup a combobox is populated by all the profile files enumerated in the current MBV folder.
You can so select in one click your current profile in the combobox visible on the main page of MBV UI (or as argument in MBVConsole), and also select the predefined “Minimum” or “Full” profile.
Selecting the Minimum profile will select only the queries of the “Important” category as opposed the Full profile selecting all the queries of all the categories.
This quick selection of a predefined profile is mush faster than checking/unchecking manually the queries in each category.
This version of MBV is available as an attachment in that post.
I look forward to have your feedbacks on that version and you can contact me of course if you want to report issue or suggestions.
in next posts I will discuss more about the global options of MBV to cutomize the report according to your own needs .
You have indeed the possibility to keep only the sections you are interested by, just by changing some global options. Stay tuned so !
Thanks !
JP
Blog Post by: JPAUC