SQL Server Customer Advisory Team - SQL Server Best Practices

Whitepapers

Database Mirroring Best Practices and Performance Considerations

Rate This

admin

19 Nov 2007 6:29 AM

Comments 8

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.

Performance, SQL, Availability, Mirroring, OLTP

Your comment has been posted. Close

Thank you, your comment requires moderation so it may take a while to appear. Close