Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Mirror instance separation
Message
De
19/01/2009 11:19:37
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Mirror instance separation
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01375099
Message ID:
01375099
Vues:
52
The MS Press, SQL Server 2005 Implementation and Maintenance book (pg 637) indicates that High Performance operating mode of a database mirror can have "greater geographic separation between the principal and the mirror" because the transaction transfers are asynchronous. The High Availability mode requires the transaction be confirmed on both the primary and the mirror before it will send a commit confirmation to the application.

My question is, what level of a performance hit would a High Availability mode mirror with principal on the east coast and mirror on the west cost have ?
Thank You

Rollin Burr

Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform