biztalkbiztalk-2010mbvbhm

Is there a way to get at the queries used in the MBV / BHM

Is there a way to get at/extract the queries used in the Message Box Viewer / BizTalk Health Monitor?

Solution

  • Regarding the SQL queries:

    The MBV Q&A file mentions this 

    Q: Where do the SQL queries executed by MBV come from ?
A: Some of them come directly from BizTalk Architect Lee Graber’s "Advanced Queries" 
   document. Other queries come from Microsoft BizTalk Support teams or known SQL & 
   BizTalk Troubleshooting documents.

    The .doc file with the paper can be found here (mirror site I found):

    Another way to do this, would be to use SQL Profiler to see what commands are being sent to SQL to see which queries are being executed.