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???
  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
  3. ghemant Moderator

    True, their is nothing new added to HA section,but yes their are some add-ons to existing HA.
  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.

Share This Page