August 24, 2017 at 2:44 pm
Hello,
For mirroring (synchronous) it first commits transaction in standby and then it gets committed in primary, hw is that process difernt in Alwayson (Sync)?
Similarly, how is the difference of Mirror (Ashyn) Vs Alwayson Asyn?
Thanks.
August 24, 2017 at 2:47 pm
For AlwaysOn AG synchronization, the following article explains it well: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability-modes-always-on-availability-groups
For mirroring synchronization, the following article explains it well: https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-operating-modes
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 24, 2017 at 3:57 pm
Can you provide some quick easy difference articles which are available?
Thanks.
September 1, 2017 at 5:13 am
SQL-DBA-01 - Thursday, August 24, 2017 2:44 PMFor mirroring (synchronous) it first commits transaction in standby and then it gets committed in primary, hw is that process difernt in Alwayson (Sync)?
Errr, no.
Transaction is always comitted to the Primary first, if synchronised and in synchronous mode the primary waits for the secondary to acknowledge the transaction is hardened to the secondary log before returning confirmation to the client.
Suggest you read the 2 links provided carefully
SQL-DBA-01 - Thursday, August 24, 2017 2:44 PM
Similarly, how is the difference of Mirror (Ashyn) Vs Alwayson Asyn?
There's little difference they are essentially one of the same
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply