none
SQL Server 2008 R2 Standard Mirroring Features

Answers

  • The single thread mentioned refers to that only one thread will be used by the REDO queue of database mirroring system in Std edition . But in Enterprise edition , it follows the formula Redo threads =  FLOOR ((number of logical processors +3) / 4) . Synchronous mode - SAFETY is always set to FULL ( Transactions gets committed at both the partners simultaneously)
     
    Bottom line - If that is a busy system with lot of transactions then go for Enterprise edition and use asynchronous mode of database mirroring.


    Thanks, Leks
    • Marked as answer by rroberts Monday, January 17, 2011 11:33 PM
    Monday, January 17, 2011 11:19 PM

All replies

  • The single thread mentioned refers to that only one thread will be used by the REDO queue of database mirroring system in Std edition . But in Enterprise edition , it follows the formula Redo threads =  FLOOR ((number of logical processors +3) / 4) . Synchronous mode - SAFETY is always set to FULL ( Transactions gets committed at both the partners simultaneously)
     
    Bottom line - If that is a busy system with lot of transactions then go for Enterprise edition and use asynchronous mode of database mirroring.


    Thanks, Leks
    • Marked as answer by rroberts Monday, January 17, 2011 11:33 PM
    Monday, January 17, 2011 11:19 PM
  • Thank you very much!

    rroberts

    Monday, January 17, 2011 11:35 PM