Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Mirror instance separation
Message
From
19/01/2009 11:19:37
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Mirror instance separation
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01375099
Message ID:
01375099
Views:
47
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.
Next
Reply
Map
View

Click here to load this message in the networking platform