August 3, 2010 at 9:48 am
I'm building a four-node Windows 2008 R2/SQL Server 2008 R2 active/active cluster, and high availability is by far the main criteria with this deployment. As a result, would it be better to use an MSDTC resource group for each SQL node?
Also, according to this TechNet blog, if there's no clustered DTC resource group, SQL Server will use its local DTC instance.
http://blogs.msdn.com/b/sqlserverfaq/archive/2010/06/04/can-i-listen-to-you-mr-msdtc.aspx
If that's the case, would I even need a clustered DTC resource group?
Any help on what's best way on configuring Microsoft DTC in a active/active SQL cluster would be very appreciated, as there's multiple ways of implementing it, and I'm not sure what would be best.
August 4, 2010 at 11:55 am
Windows 2008 now offers the ability to create multiple clustered DTC resources, you could have one for each instance or just use the one
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 4, 2010 at 12:11 pm
Two advantages of using a dedicated MSDTC instance for each SQL instance are:
(1) Better performance: The MSDTC always runs on the same physical node as SQL Server, minimizing communications overhead.
(2) Reduced failure footprint: Failure of one MSDTC will not affect applications running on other cluster nodes.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply