Feb 10, 2020
Distributed Transactions Suck!
Distributed Transactions Suck! #SQL
Microsoft SQL Server does not need a Microsoft distributed transaction coordinator (MS-DTC) to work. However, applications can use it without the database administrator’s (DBA’s) knowledge. In most cases, it is no harm.
DBA’s don’t need to know. Right? Wrong! If your application is using DTC, make sure DBA knows about it. Why? Organizations are using AlwaysOn Availability Groups more and…
View On WordPress