Performance tuning in database mirroring is directly proportional to
server speed, network bandwidth and speed, and disk drive characteristics.
Performance is also strongly influenced by the safety model chosen
and the underlying communication method it employs.
Database Mirroring Operating Modes:
* High availability
* High protection
* High performance
Specifically, high availability and high protection use synchronous mirroring,
and high performance uses asynchronous.
These decisions are usually taken in conjunction with the business users
and are part of the service level agreement for acceptable recovery times,
costs of the system being designed, and acceptable exposure levels.
Source:
Microsoft SQL 2005 Administrator's Companion,
Chapter 27 - Log Shipping and Database Mirroring
Page 899