|
SQL Server Best Practices ArticlePublished: March 10, 2006
Writers: Sanjay Mishra
Technical Reviewers: Brian Goldstein, Lubor Kollar, Mike Ruthruff, Steven Wort, Prem Mehra, Peter Byrne, Mark Wistrom, Jakub Kulesza, Juergen Thomas, Michael Raheem, Allan Hirt (Avanade) Maximizing the availability of databases is on the top priority list for many database administrators worldwide. Database mirroring is a new feature in SQL Server 2005 that can help minimize planned and unplanned downtime, thereby maximizing the availability of the database. Database mirroring transports the changes in the production database to a mirror database, either synchronously or asynchronously. The mirror database can reside either in the same data center to provide a high-availability solution, or in a remote data center to provide a disaster-recovery solution. Business requirements such as service-level agreements and performance, as well as technical factors such as log generation rate, network throughput, and I/O throughput, influence the deployment of database mirroring. This paper discusses best practices and performance considerations for implementing database mirroring.For more information, please refer to the Database Mirroring Best Practices and Performance Considerations whitepaper.
|
|
|
