February 18, 2019 at 3:26 am
hello everybody
on a same mirroirng server
Is it possible to have bases in synchronous mode and others in asynchronous mode
thanks
February 18, 2019 at 6:32 am
Hi,
it depends, synchronous is a standard feature, asynchronous is a enterprise feature.
If you got a enterprise sql server, you can put one mirrored datebase to sync, the other to async.
Kind regards,
Andreas
February 18, 2019 at 7:44 am
why the asynchronous mode exists only in the enterprise edition
Is it true that the asynchronous mode is more efficient than the synchronous mode
February 18, 2019 at 8:44 am
abdalah.mehdoini - Monday, February 18, 2019 7:44 AMwhy the asynchronous mode exists only in the enterprise edition
Is it true that the asynchronous mode is more efficient than the synchronous mode
Define "more efficient".
In asynchronous mode (high-performance), the transactions are committed on the principal first, and then transferred to the mirror. In the event of a failover, there may be data loss. How much depends upon a number of factors.
In synchronous mode (high-safety), transactions are committed on both servers at the same time. Again, depending upon various factors, this may affect performance on the principal. You also need this to be able to do an automatic failover.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply