SQL Server Performance

SQL 2008 HA

Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by Akthar, Mar 28, 2008.

  1. Akthar New Member

    i have been playing around with the NOV CTP, and i cant see much changes in the High Availabiliy except for the corrupt pages recovery.
    Will there be any new features in the Final Release???
    Akthar, Mar 28, 2008
    #2

  2. madhuottapalam New Member

    There are few enhancements in Database mirroring
    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.
    Improved use of log send buffers.
    Page read-ahead during the undo phase.
    Madhu
    madhuottapalam, Mar 28, 2008
    #3

  3. ghemant Moderator

    True, their is nothing new added to HA section,but yes their are some add-ons to existing HA.
    ghemant, Mar 31, 2008
    #4

  4. satya Moderator

    What is the size of database you have been playing with?
    I can say consistent enhancement with regard to DB mirroring within SQL 2008, where we have tested with a 50 gb to 400gb database with active transactions, the speed has increased as compared to SQL 2005.
    satya, Mar 31, 2008
    #5

Share This Page