SQLSACT (4/16/2013)
Nope - All Servers are in the same DC
DC?
SQLSACT (4/16/2013)
Would it make a difference if it was spanned across multiple sites?
It's a consideration, yes.
SQLSACT (4/16/2013)
Doesn't this take away from the seperate storage selling point of AG's combined with FCI?
No, the storage for the MSDTC is not part of the failover cluster instance.
SQLSACT (4/16/2013)
I'm no pro at HA but I can't seem to think of a logical reason why automatic failover is not supported when you have an FCI.
What would happen if the AO group attempted automatic failover whilst the FCI was in failover mode?
SQLSACT (4/16/2013)
Hmm, Gonna have to rethink my approach thenSo it's basically a tradeoff, You can have 2 nodes available to your primary but then you wont have automatic failover for your AG OR you can have a single node available to your primary and then have the safety of Automatic failover.
It is what it is, read the pre reqs and restrictions carefully to ensure you have no further surprises.
Keep an eye out for my next major article around this exact subject, Combining AO with FCI 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉