locked
SQL AlwaysOn support in BizTalk 2016 version RRS feed

  • Question

  • Microsoft indicated in its latest Integration Roadmap that SQL AlwaysOn high availability will be supported starting with BizTalk Server 2016 version. That's great because that will simplify the on premise HA and DR solutions with BizTalk Server. Also high availability for production instances can be implemented easily within Azure IAAS instances. 

    So far the SQL AlwaysOn itself did not support the cross database transactions and distributed transactions. And that resulted in BizTalk not supporting SQL AlwaysOn because cross database and distributed transactions are integral part of BizTalk functionality.  SQL 2016 will support both these features for AlwaysOn and hence BizTalk 2016 will be able to support SQL AlwaysOn for high availability. But SQL 2016 AlwaysOn still has some constraints in terms of support for these features. These are listed in following MSDN link - https://msdn.microsoft.com/en-us/library/ms366279.aspx
    "Cross-database transactions within the same SQL Server instance are not supported for AlwaysOn Availability Groups. This means that no two databases in a cross-database transaction may be hosted by the same SQL Server instance. This is true even if those databases are part of the same Availability Group"

    So does that mean we can not host BizTalk databases in same SQL Server Instance to avail the AlwaysOn high availability with BizTalk 2016?


    Wednesday, March 30, 2016 4:01 PM

Answers

  • What about cross database transactions within same SQL server instance? That was my question. Typical small BizTalk installations have single SQL server instance housing all BizTalk databases.

    Yes, Currently Cross-database transactions within the same SQL Server 2016 instance are not supported for AlwaysOn Availability Groups and therefore this limitation will apply to BizTalk database as well.

    But having said that its very premature to arrive to some sort of judgement or conclusion. This note applies to SQL server 2016 Preview version and there have been many CTP/RC builds release post that. With a very open public preview program starting with CTP 2.0, SQL Server 2016 is getting into a lot of hands and getting put through a lot of testing. There will be many more Service Packs (SP), Cumulative Updates (CU), patches, hotfixes and other builds lined up.

    As BizTalk Server 2016 is scheduled for General Availability (GA) in the fall of 2016 we can expect many things getting unfolded with time.


    Announcing BizTalk Server 2016 Community Technology Preview 1!

    BizTalk Server 2016 What's New

    Make sure you follow these blogs as Microsoft product team will be posting details on each of the new features and how to use them in the coming days.


    Rachit Sikroria (Microsoft Azure MVP)

    • Proposed as answer by Angie Xu Thursday, April 7, 2016 2:23 AM
    • Marked as answer by Angie Xu Thursday, April 7, 2016 2:23 AM
    Friday, April 1, 2016 7:30 PM
    Moderator

All replies


  • So does that mean we can not host BizTalk databases in same SQL Server Instance to avail the AlwaysOn high availability with BizTalk 2016?

    cross-database transactions between databases hosted by different SQL Server instances are supported in SQL Server 2016.

    Have a good day.  

    Regards,

    Angie


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Thursday, March 31, 2016 6:20 AM
  • What about cross database transactions within same SQL server instance? That was my question. Typical small BizTalk installations have single SQL server instance housing all BizTalk databases.

    Thursday, March 31, 2016 6:11 PM
  • What about cross database transactions within same SQL server instance? That was my question. Typical small BizTalk installations have single SQL server instance housing all BizTalk databases.

    Yes, Currently Cross-database transactions within the same SQL Server 2016 instance are not supported for AlwaysOn Availability Groups and therefore this limitation will apply to BizTalk database as well.

    But having said that its very premature to arrive to some sort of judgement or conclusion. This note applies to SQL server 2016 Preview version and there have been many CTP/RC builds release post that. With a very open public preview program starting with CTP 2.0, SQL Server 2016 is getting into a lot of hands and getting put through a lot of testing. There will be many more Service Packs (SP), Cumulative Updates (CU), patches, hotfixes and other builds lined up.

    As BizTalk Server 2016 is scheduled for General Availability (GA) in the fall of 2016 we can expect many things getting unfolded with time.


    Announcing BizTalk Server 2016 Community Technology Preview 1!

    BizTalk Server 2016 What's New

    Make sure you follow these blogs as Microsoft product team will be posting details on each of the new features and how to use them in the coming days.


    Rachit Sikroria (Microsoft Azure MVP)

    • Proposed as answer by Angie Xu Thursday, April 7, 2016 2:23 AM
    • Marked as answer by Angie Xu Thursday, April 7, 2016 2:23 AM
    Friday, April 1, 2016 7:30 PM
    Moderator