Post reply

SQL MIrroring

  • December 12, 2012 at 3:02 am

    #271825

    I recently configured on database in mirroring with automatic failover.I want to push 10 GB of data into primay server and I want to find how much time it would take to synchronise these data to mirror server.

    Please help

  • December 12, 2012 at 3:17 am

    #1567784

    Akkare (12/12/2012)

    I recently configured on database in mirroring with automatic failover.I want to push 10 GB of data into primay server and I want to find how much time it would take to synchronise these data to mirror server.

    Please help

    depends on below factors.

    1) IO speed or disk RPM

    2) network speed

    3) what other processes running on same machine which are also using resources etc etc

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • December 13, 2012 at 12:11 am

    #1568169

    Also edition of mirrored server plays a significant role when it comes to synchrnoization.Enterprise editon will use "Parallel redo" using more threads available to mirroring session If you have more than 5 cpu.

  • December 13, 2012 at 12:30 am

    #1568173

    dbasql79 (12/13/2012)

    Also edition of mirrored server plays a significant role when it comes to synchrnoization.Enterprise editon will use "Parallel redo" using more threads available to mirroring session If you have more than 5 cpu.

    thanks ..New to me ...Any article ? 🙂

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • December 13, 2012 at 1:06 am

    #1568182

    Sure,

    http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx

  • December 13, 2012 at 3:04 am

    #1568220

    Thanks for the link..

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply