locked
what is exact difference between sql 2005 and 2008 in mirroring? RRS feed

  • Question

  • what is internal difference between sql 2005 and 2008 in mirroring.

    Saturday, December 10, 2011 3:49 AM

Answers

  • what is internal difference between sql 2005 and 2008 in mirroring.


    Below is the short list.  See http://msdn.microsoft.com/en-us/library/cc645581(v=SQL.100).aspx for details.

    • Write-ahead on the incoming log stream on the mirror server.
    • Improved use of log send buffers.
    • 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.

    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    • Proposed as answer by amber zhang Monday, December 12, 2011 5:01 AM
    • Marked as answer by amber zhang Friday, December 16, 2011 7:00 AM
    Saturday, December 10, 2011 3:57 AM
  • Also few more

    • Automatic page repair. SQL Server 2008 enables the principal and mirror computers to transparently recover from 823 and 824 errors on data pages by requesting a fresh copy of the corrupted page from the mirroring partner.
    • Improved performance. SQL Server 2008 compresses the outgoing log stream in order to minimize the network bandwidth required by database mirroring.
    • Enhanced supportability
    • SQL Server 2008 includes additional performance counters to enable more granular accounting of the time spent across the different stages of Database Management System (DBMS) log processing.
    • SQL Server 2008 includes new Dynamic Management Views and extensions of existing views to expose additional information about mirroring sessions.


    http://uk.linkedin.com/in/ramjaddu
    • Proposed as answer by amber zhang Monday, December 12, 2011 5:01 AM
    • Marked as answer by amber zhang Friday, December 16, 2011 7:00 AM
    Saturday, December 10, 2011 8:53 AM

All replies

  • what is internal difference between sql 2005 and 2008 in mirroring.


    Below is the short list.  See http://msdn.microsoft.com/en-us/library/cc645581(v=SQL.100).aspx for details.

    • Write-ahead on the incoming log stream on the mirror server.
    • Improved use of log send buffers.
    • 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.

    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    • Proposed as answer by amber zhang Monday, December 12, 2011 5:01 AM
    • Marked as answer by amber zhang Friday, December 16, 2011 7:00 AM
    Saturday, December 10, 2011 3:57 AM
  • Also few more

    • Automatic page repair. SQL Server 2008 enables the principal and mirror computers to transparently recover from 823 and 824 errors on data pages by requesting a fresh copy of the corrupted page from the mirroring partner.
    • Improved performance. SQL Server 2008 compresses the outgoing log stream in order to minimize the network bandwidth required by database mirroring.
    • Enhanced supportability
    • SQL Server 2008 includes additional performance counters to enable more granular accounting of the time spent across the different stages of Database Management System (DBMS) log processing.
    • SQL Server 2008 includes new Dynamic Management Views and extensions of existing views to expose additional information about mirroring sessions.


    http://uk.linkedin.com/in/ramjaddu
    • Proposed as answer by amber zhang Monday, December 12, 2011 5:01 AM
    • Marked as answer by amber zhang Friday, December 16, 2011 7:00 AM
    Saturday, December 10, 2011 8:53 AM