Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

alwayson - cross database transactions and cross server transactions Expand / Collapse
Author
Message
Posted Thursday, March 20, 2014 12:54 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 8:51 AM
Points: 394, Visits: 1,977
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?
Post #1553210
Posted Monday, March 24, 2014 8:44 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 12:54 PM
Points: 611, Visits: 439
Which link you referred here , please elaborate .
Post #1554067
Posted Tuesday, March 25, 2014 11:18 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, September 11, 2014 2:28 PM
Points: 1,194, Visits: 2,219
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
Post #1554602
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse