MSDTC and Always On AG

• VastSQL

  SSC-Dedicated

  Points: 36097

  More actions

  February 28, 2021 at 4:49 am

  #3851205

  Hi Experts,

  We are planning to implement 2 Node AO SQL Server 2019. For MSDTC what is the best practice? Do we need a cluster disk for MSDTC alone in this setup?

  https://techcommunity.microsoft.com/t5/core-infrastructure-and-security/msdtc-best-practices-with-an-availability-group/ba-p/909429

   

• Michael L John

  One Orange Chip

  Points: 27055

  More actions

  March 1, 2021 at 1:36 am

  #3851454

  If this is an availability group, why do you need shared storage?

  We configured it separately on each server.

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/

• March 1, 2021 at 8:41 am

  This was removed by the editor as SPAM

• VastSQL

  SSC-Dedicated

  Points: 36097

  More actions

  March 6, 2021 at 7:38 pm

  #3854293

  Michael L John wrote:

  If this is an availability group, why do you need shared storage?

  We configured it separately on each server.

   

  Thanks Michael. As per the link we need to configure the cluster disk, does configure local have any negative impact?

  https://techcommunity.microsoft.com/t5/core-infrastructure-and-security/msdtc-best-practices-with-an-availability-group/ba-p/909429