Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
what is exact difference between sql 2005 and 2008 in mirroring?

Answered what is exact difference between sql 2005 and 2008 in mirroring?

  • Saturday, December 10, 2011 3:49 AM
     
     
    Sign In to Vote
    0

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

     

All Replies

  • Saturday, December 10, 2011 3:57 AM
     
     Answered
    Sign In to Vote
    0

    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/
     
  • Saturday, December 10, 2011 8:53 AM
     
     Answered
    Sign In to Vote
    0

    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