Post reply

Cluster failover - How much time needed?

  • February 23, 2009 at 3:19 am

    #155312

    I read that during failover SQL Server resources startup on the new node and databases go through normal recovery processes. I guess, this will take longer time for larg databases (around 30 GB).

    I am planning to implement failover custering for HA. However, not sure how much time it will take to failover. If anyone has any idea now much time it takes for the databases to be available please share it.

    Thanks

  • February 23, 2009 at 7:31 am

    #948582

    Suresh B. (2/23/2009)

    If anyone has any idea now much time it takes for the databases to be available please share it.

    Depends on how much work SQL has to do in the restart-recovery. If the DB was shut down cleanly, it'll take less time than if it was an uncontrolled shutdown. Also depends on the speed of the disks (especially the log drive), and any other activity on the servers.

    Test it on your system. Too many variables to be able to give you a concrete answer.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 24, 2009 at 10:44 am

    #949535

    Present Day:

    1 Tb db, 1/4 Tb db, 1/3 Tb db on an activer/passive cluster.

    failover of all resources from one node to the other via cluster administrator 1-2 minutes.

    when active node crashes - 3-5 minutes

    This is IBM NUMA HW.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • February 24, 2009 at 11:19 pm

    #949801

    Thanks Rudy

Viewing 4 posts - 1 through 3 (of 3 total)

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