none
Monitor BAHS Adapters Performance RRS feed

  • Question

  • Hi,

    There are four Biztalk Adapters provided by BAHS:
    • Microsoft BizTalk Adapter for WebSphere MQ (MQSC adapter) (Client-Based) 
    • Microsoft BizTalk Adapter for DB2
    • Microsoft BizTalk Adapter for Host Files
    • Microsoft BizTalk Adapter for Host Applications
    Can you please let me know how can I monitor their performance. Are there any WMI classes or Perfmon objects for the same.

    Please provide the supporting links/urls.

    ashu
    • Edited by Ashwani26 Wednesday, September 23, 2009 5:46 AM typo
    Friday, September 18, 2009 8:15 AM

Answers

  • Ashu,

    What exactly do you mean by monitoring adapter performance?

    With the HAT, for example (Start Menu / BTS / Health and Activity Monitoring) you can see how long it takes to process messages and which ones are suspended.
    You can start, with "Most recent 100 service instances"
    Friday, September 18, 2009 5:55 PM
  • Hi,

    In BizTalk 2009, HAT has been part of BizTalk Administration Console. When we click the "BizTalk Group" Node We can do the same thing there as it was in HAT of BizTalk 2006.
    There is a blog tells how to use "HAT" in BizTalk 2009(beta):
    http://kentweare.blogspot.com/2009/01/biztalk-2009-beta-wheres-my-hat.html

    Regards
    Microsoft Online Community Support
    Wednesday, September 23, 2009 6:14 AM
    Moderator

All replies

  • Ashu,

    What exactly do you mean by monitoring adapter performance?

    With the HAT, for example (Start Menu / BTS / Health and Activity Monitoring) you can see how long it takes to process messages and which ones are suspended.
    You can start, with "Most recent 100 service instances"
    Friday, September 18, 2009 5:55 PM
  • PS HAT is only available in BTS 2006.
    Friday, September 18, 2009 6:02 PM
  • And, of course, there is ESB Guidance:

    http://www.microsoft.com/biztalk/en/us/esb-guidance.aspx
    Friday, September 18, 2009 6:06 PM
  • Yeah, Alex is right, I tried loading HAT on BizTalk 2009 and it would not open correctly. I did try one of the SQL queries from BizTalk 2006 HAT on my BizTalk 2009 instance in SQL Management Studio and it ran fine, although I am not sure if this works for all of them. I did have to initialize the variables though. For example, here is the query for the most recent 100 service instances:


    -- Added this next line
    declare @UTCOffsetMin int

    SELECT top 100
     [Service/Name], [Service/Type],
     [ServiceInstance/State],
     dateadd(minute, @UtcOffsetMin, [ServiceInstance/StartTime]) as [StartTime], -- can't use 'as [ServiceInstance/StartTime]' since this prevents SQL from using index on that column (conflicts with ORDER BY)
     dateadd(minute, @UtcOffsetMin, [ServiceInstance/EndTime]) as [EndTime], -- can't use 'as [ServiceInstance/EndTime]' since this prevents SQL from using index on that column (conflicts with ORDER BY)
     [ServiceInstance/Duration],
     [ServiceInstance/ExitCode],
     [ServiceInstance/ErrorInfo],
     [ServiceInstance/Host],
     [Service/AssemblyName],
     [ServiceInstance/InstanceID],
     [ServiceInstance/ActivityID],
     [Service/ServiceGUID],
     [Service/ServiceClassGUID]
    FROM dbo.dtav_ServiceFacts sf WITH (READPAST)
    ORDER BY sf.[ServiceInstance/StartTime] desc

    I will check on some performance counters for BAH a post back soon.

    Thanks,


    If this answers your question, please use the "Answer" button to say so | Ben Cline
    Friday, September 18, 2009 9:48 PM
    Moderator
  • I found a performance counter category called MSFT DB2 access library, which has quite a few counters. 

    I am pretty sure I remember seeing WebSphere MQ client counters as well.

    Thanks,
    If this answers your question, please use the "Answer" button to say so | Ben Cline
    Friday, September 18, 2009 10:19 PM
    Moderator
  • Hi,

    In BizTalk 2009, HAT has been part of BizTalk Administration Console. When we click the "BizTalk Group" Node We can do the same thing there as it was in HAT of BizTalk 2006.
    There is a blog tells how to use "HAT" in BizTalk 2009(beta):
    http://kentweare.blogspot.com/2009/01/biztalk-2009-beta-wheres-my-hat.html

    Regards
    Microsoft Online Community Support
    Wednesday, September 23, 2009 6:14 AM
    Moderator