alwayson - cross database transactions and cross server transactions

  • as alwayson doesn't support cross database transactions and cross server transactions based on the below link. I am trying to understand what would be affect of this in a high transactional environment. I am trying to find an example which clearly explains the scenarios. Can someone help me out understand the affects if we go for cross db transactions?

  • Which link you referred here , please elaborate .

  • muthyala_51 (3/20/2014)


    as alwayson doesn't support cross database transactions and cross server transactions based on the below link. I am trying to understand what would be affect of this in a high transactional environment. I am trying to find an example which clearly explains the scenarios. Can someone help me out understand the affects if we go for cross db transactions?

    Always ON doesn't support Cross DB Transactions and Distributed Transactions. So why would you use that and also concerned about highly transactional environment ? You should be worried only if you have Cross DB Transactions and Distributed Transactions.

    Check this ..

    http://msdn.microsoft.com/en-us/library/ms366279.aspx

    --

    SQLBuddy

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply