Home
%3CLINGO-SUB%20id%3D%22lingo-sub-786632%22%20slang%3D%22en-US%22%3EIntroducing%20Distributed%20transaction%20functionality%20on%20SQL%20Server%202017%20on%20Linux%20starting%20with%20CU16%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-786632%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EDistributed%20transactions%20form%20a%20vital%20member%20in%20distributed%20systems%20architecture.%20It%20provides%20ACID%20(Atomicity%2C%20Consistency%2C%20Isolation%20and%20Durability)%20properties%20to%20transactions%20that%20span%20across%20systems%20using%20two-phase%20commit.%20On%20Windows%20operating%20systems%2C%20Microsoft%20Distributed%20Transaction%20Coordinator%20(MSDTC)%20service%20has%20provided%20the%20capability%20to%20perform%20distributed%20transactions%20since%20Windows%20NT%204.0%20and%202000%20servers.%20SQL%20Server%20has%20used%20this%20capability%20on%20Windows%20systems%20to%20provide%20distributed%20transaction%20functionality.%20This%20allows%20SQL%20Servers%20to%20enlist%20in%20distributed%20transactions%20while%20providing%20transactional%20guarantees.%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EWith%20SQL%20Server%202017%2C%20a%20new%20era%20was%20heralded%20with%20SQL%20server%20being%20available%20to%20deploy%20on%20Linux%20(and%20Linux%20based%20container)%20systems.%20While%20all%20functionality%20of%20the%20SQL%20Server%20engine%20were%20brought%20over%20as%20is%20to%20SQL%20Server%20on%20Linux%2C%20some%20of%20the%20functionality%20which%20depended%20on%20Windows%20system%20processes%20such%20as%20distributed%20transactions%20(which%20relies%20on%20MSDTC%20service)%20were%20not%20brought%20over%20immediately.%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EWith%20SQL%20Server%202019%20CTP%202.1%2C%20we%20introduced%20support%20for%20distributed%20transaction%20support%20for%20SQL%20Server%20on%20Linux%20deployments%2C%20by%20bringing%20Distributed%20Transaction%20Coordinator%20components%20within%20SQLPAL%2C%20the%20Platform%20Abstraction%20Layer%20which%20allows%20the%20same%20SQL%20Server%20to%20run%20against%20Linux%20operating%20systems.%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EToday%20we%20are%20glad%20to%20announce%20that%20we%20have%20brought%20the%20distributed%20transaction%20support%20for%20SQL%20Server%202017%20on%20Linux%20deployments%20starting%20with%20SQL%20Server%202017%20CU16.%20You%20can%20read%20more%20about%20how%20to%20configure%20SQL%20Server%20and%20Linux%20system%20to%20enable%20distributed%20transactions%20%3CA%20title%3D%22How%20to%20configure%20the%20Microsoft%20Distributed%20Transaction%20Coordinator%20(MSDTC)%20on%20Linux%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Flinux%2Fsql-server-linux-configure-msdtc%3Fview%3Dsql-server-2017%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eon%20this%20page%3C%2FA%3E%3C%2FSPAN%3E%3CSPAN%3E.%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ERobert%20Dorr%20%E2%80%93%20Principal%20Software%20Engineer%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EKapil%20Thacker%20%E2%80%93%20Senior%20Software%20Engineer%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EVal%20Menn%20%E2%80%93%20Senior%20Software%20Engineer%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EBen%20Ko%20%E2%80%93%20Senior%20Software%20Engineer%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EMike%20Habben%20%E2%80%93%20Principal%20Software%20Engineering%20Manager%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ETejas%20Shah%20%E2%80%93%20Senior%20Program%20Manager%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-786632%22%20slang%3D%22en-US%22%3E%3CP%3EDistributed%20transaction%20functionality%20is%20available%20with%20SQL%20Server%202017%20on%20Linux%20starting%20CU16.%20Find%20out%20more%20about%20how%20to%20configure%20it.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-786632%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerTiger%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787950%22%20slang%3D%22en-US%22%3ERe%3A%20Introducing%20Distributed%20transaction%20functionality%20on%20SQL%20Server%202017%20on%20Linux%20starting%20with%20CU16%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787950%22%20slang%3D%22en-US%22%3E%3CP%3EAwesome%20--%20is%20CDC%20support%20next%3F%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

Distributed transactions form a vital member in distributed systems architecture. It provides ACID (Atomicity, Consistency, Isolation and Durability) properties to transactions that span across systems using two-phase commit. On Windows operating systems, Microsoft Distributed Transaction Coordinator (MSDTC) service has provided the capability to perform distributed transactions since Windows NT 4.0 and 2000 servers. SQL Server has used this capability on Windows systems to provide distributed transaction functionality. This allows SQL Servers to enlist in distributed transactions while providing transactional guarantees.

With SQL Server 2017, a new era was heralded with SQL server being available to deploy on Linux (and Linux based container) systems. While all functionality of the SQL Server engine were brought over as is to SQL Server on Linux, some of the functionality which depended on Windows system processes such as distributed transactions (which relies on MSDTC service) were not brought over immediately.

With SQL Server 2019 CTP 2.1, we introduced support for distributed transaction support for SQL Server on Linux deployments, by bringing Distributed Transaction Coordinator components within SQLPAL, the Platform Abstraction Layer which allows the same SQL Server to run against Linux operating systems.

Today we are glad to announce that we have brought the distributed transaction support for SQL Server 2017 on Linux deployments starting with SQL Server 2017 CU16. You can read more about how to configure SQL Server and Linux system to enable distributed transactions on this page.

 

Robert Dorr – Principal Software Engineer

Kapil Thacker – Senior Software Engineer

Val Menn – Senior Software Engineer

Ben Ko – Senior Software Engineer

Mike Habben – Principal Software Engineering Manager

Tejas Shah – Senior Program Manager

 

1 Comment
Occasional Visitor

Awesome -- is CDC support next? :)