re: What is BizTalk MsgBoxViewer ?

Dilip — Fri, 25 Jul 2008 09:04:07 GMT

HI ,

Great Job Done . i was developing the same application for biztalk to get all the information stored in the Biztalk DB but was lacking some where because of the understanding of the tables in database.

can u please gimme the code snippet of it . If possible than please tell me where i can read about the Biztalk Database relationships.

Thanks .

waiting for your response

dilipsingh_20032003@yahoo.com

Thanks

re: What is BizTalk MsgBoxViewer ?

jpierauc — Mon, 28 Jul 2008 20:48:07 GMT

Hi Dilip,

thanks for your comment !

MBV code is not public as it contains some internal SQL queries and comments...

However, as I say in my Q&A, some of the MBV queries come directly from former BizTalk architecture Lee Graber in its "avanced Msgbox Queries

http://home.comcast.net/~sdwoodgate/BizTalkServer2004AdvancedMessageBoxQueries.doc?

I just modified them to be able to target multiple msgboxes configurations or use them with any names specified for the BizTall dbs.

Then I collected all other interesting SQL queries that our BizTalk Product Group had send to us since few years to help troubleshooting BizTalk production issues on large BizTalk dbs

For performance issues and to avoid any contention on very busy and large msgboxes db, we do NOT recommend to send SQL queries direcly to BizTalk dbs, specially the MsgBodx db.

BizTalk MMC, HAT, or Biztalk WMI provider are provided for that and they do that quite well their role using optimized and tested queries.

Remember that we have lot of publishing SQL queries + each 500 ms max (by default) lot of dequeue queries + subscription evaluation queries + several SQL jobs running each minutes or even for one of them looping each 10Seconds to clean unreferenced msgs in the System, so we need to avoid sending costly queries which could bring to locks/deadlocks or orphaned SPIDs situations.

I have also classic WMI queries in MBV but mainly to get System info.

I'm not aware of public docs describing in details each Biztalk msgbox tables (even if I think we have some articles on MSDN presenting some tables), but for some good in depth technical discussions on BizTalk and its databases, I can recommend you the BizTalk Core Engine's WebLog link :

http://blogs.msdn.com/Biztalk_Core_Engine/

and this one on perfs :

http://blogs.msdn.com/biztalkperformance/default.aspx

and Biztalk PG blog

hope it can help

re: What is BizTalk MsgBoxViewer (aka "MBV") ?

tsls — Wed, 21 Jan 2009 20:21:08 GMT

Great tool

How would you rectify the following

Control Message Check Missing Restart Msg in Spool table (can prevent some svc instances to be resumed, terminated or suspended) !!

re: What is BizTalk MsgBoxViewer (aka "MBV") ?

tsls — Thu, 22 Jan 2009 01:53:11 GMT

Found answer here: http://blogs.technet.com/jpierauc/archive/2008/07/22/msgboxviewer-mbv-q-a.aspx