Introduction
As you may know, in the early days of SQL Server Clustering, Microsoft advised to provide each clustered SQL Server instance with its own Microsoft Distributed Transaction Coordinator (MSDTC) resource. Since SQL Server 2012 this advice has been withdrawn. Microsoft now recommends to provide your instance with its own MSDTC resource, once you notice the Local MSDTC resource cannot cope with the load it receives.
Now we are using Windows 2022 and MS clustering improved massively over time.
How did this escalate?
As many of us, I overlooked this change in guidance. Until now, as I was reading the guidelines once