none
BizTalk pooling RRS feed

  • Question

  • I have a SQL receive location in BizTalk group comprising of 3 nodes, if my receive location is set to pole one record per a sql query every 10 seconds, 

    Question is will it call 3 records (Since it has 3 nodes in that group and 3 host instance) or will it call once instead of three?

    Sunday, June 30, 2019 11:37 AM

Answers

  • The Receive Location will fire once per interval per running Host Instances.

    So if you have, say, RecHost running on three computers, SQL Server will get polled 3 time every 10 seconds.

    Polling Receive Locations is one of use cases for Host Clustering.

    • Proposed as answer by Colin Dijkgraaf Sunday, June 30, 2019 8:20 PM
    • Marked as answer by SOS 111 Monday, July 29, 2019 11:41 PM
    Sunday, June 30, 2019 1:57 PM
    Moderator

All replies

  • The Receive Location will fire once per interval per running Host Instances.

    So if you have, say, RecHost running on three computers, SQL Server will get polled 3 time every 10 seconds.

    Polling Receive Locations is one of use cases for Host Clustering.

    • Proposed as answer by Colin Dijkgraaf Sunday, June 30, 2019 8:20 PM
    • Marked as answer by SOS 111 Monday, July 29, 2019 11:41 PM
    Sunday, June 30, 2019 1:57 PM
    Moderator
  • Thankyou, interstingly it is only polling once instead of three inspite of having three host instances, what could be the reason. All hosts are online.
    Tuesday, July 2, 2019 12:40 PM