BizTalk Database queries to find the statistical data.

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › BizTalk Database queries to find the statistical data.

Viewing 1 reply thread
  • Author
    Posts
    • #19642

      Does anybody has SQL queries to extact the following data from BizTalk database. 

      1. How busy is a message hub per hour / day / week.

      2. How busy is a message hub on what time a day. Is there a message flood between 4 – 6 pm e.g.

      3. Which interface(s) are responsible for the load

    • #19686

       I dont have one, but you could construct these queries in HAT.  Just click on the “Queries Menu” ->  “Most recent 100 service instances” and then click on the “Show Query” button.  In there you can modify the query to your liking.  You can also run these queries from SQL Managment Studio (or SQL Query Analyzer).  Just point your connection at the BizTalkDTADb and query against the dtav_FindMessageFacts view.

      From there you will probably need to customize your query based on your business processes.  For instance if you have messages that support your business process(like a DB Lookup) do you want to include these in your metrics?  From within your query, you may want to include/neglect certain records based upon the Pipeline or Host that was used to process the message.

      Something else that you may want to look at, albeit more effort, is BAM.  You could definately get this type of info from there.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.