Thursday, March 22, 2012

Database Mirroring

Can you give me some details or links on the improvements to database mirroring in SQL 2008?

I don't know if this is the complete list of database mirroring improvements planned for Katmai, but the What's New (Database Engine) topic in Books Online lists the following improvements implemented in the July CTP.

Database Mirroring

Log Performance Enhancements

Compression of stream data for which at least a 12.5 percent compression ratio can be achieved.
Write-ahead on the incoming log stream on the mirror server.

In SQL Server 2008, when receiving incoming log records, the mirror server hardens them (that is, writes them to disk) asynchronously. At the same time, the mirror server processes log records that have already been hardened.
Improved use of log send buffers.

In SQL Server 2005, every log-flush operation on the principal server reserves a whole database mirroring log send buffer for its log records. In SQL Server 2008, if the most recently used log cache contains sufficient free space for the log records of the next log-flush operation, they are appended to that log cache. Otherwise, a new log cache is allocated.
Page read-ahead during the undo phase.

After a failover, the new mirror server must undo every change for which a page was written to disk locally but for which the log record might not have reached the former mirror server (the new principal server). To undo such changed pages, the mirror server must first request and receive the corresponding pages from the new principal server. Performance of this part of the undo phase is enhanced in SQL Server 2008. Early in the undo phase, the mirror server sends read-ahead hints to the principal server to indicate which pages will be requested later. After receiving a read-ahead hint for a page, the principal server puts that page in its send buffer. On receiving the corresponding page request, the principal server can respond immediately.

Automatic recovery from corrupted pages

No comments:

Post a Comment