locked
Mirroring in sql server 2008 RRS feed

  • Question

  • Any change in database mirroring in sql server 2008 compare with sql server 2005?
    Thursday, February 17, 2011 2:29 PM

Answers

All replies

  • Addition of Log Stream Compression was the big one
    Peter Carter-Greenan http://sqlserverdownanddirty.blogspot.com/
    • Marked as answer by WeiLin Qiao Sunday, February 27, 2011 2:03 PM
    Thursday, February 17, 2011 3:15 PM
  •  Add On

    --Improved use of log send buffers.
    --Write-ahead on the incoming log stream on the mirror server.
    --Compression of the stream of transaction log records.
    --Compression of stream data for which at least a 12.5 percent compression ratio can be achieved.
    --Page read-ahead during the undo phase.

     

     

    Refer the following links

    Availability Enhancements

    http://msdn.microsoft.com/en-us/library/cc645581.aspx 

    Database Mirroring Log Compression in SQL Server 2008 Improves Throughput

    http://sqlcat.com/technicalnotes/archive/2007/09/17/database-mirroring-log-compression-in-sql-server-2008-improves-throughput.aspx

    Thursday, February 17, 2011 5:39 PM
  • Oh, and Automatic Page Repair as well...
    Peter Carter-Greenan http://sqlserverdownanddirty.blogspot.com/
    • Marked as answer by WeiLin Qiao Sunday, February 27, 2011 2:03 PM
    Thursday, February 17, 2011 5:55 PM
  • In SQL Server 2005, database mirroring is an offered solution to administrators to achieve high availability. With SQL Server 2008, improvements are incorporated to the database mirroring process which greatly enhances this process

    • Proposed as answer by tonypatel Tuesday, March 22, 2011 10:33 AM
    Thursday, March 17, 2011 10:28 AM