Question about clustering

  • Hello,

    I would like to ask for some insights about SQL Server Clustering. When you fail over an instance to another node, does the cache also gets reset?

    Thank you.

  • Failing over a clustered instance is, in effect, stopping it on one node and starting it again on another. So you should expect everything that happens when you stop SQL Server to happen also when you fail it over.

    John

  • A failover involved SQL starting cold on the second node. There's no memory transfer, the databases are shared but that's all.

    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
  • Thanks for the quick reply guys.

    That's what I thought at first but I really wanted to get the opinion of experts like you guys. I'm new to this clustering thing. I'm glad there's a lot of kind experts here willing to share their knowledge.

    Thank you. 🙂

  • The shared databases represent only the upper layer of the shared objects. At the base level, each cluster node that is part of the failover instance shares the virtual IP, virtual network name and the storage disks too. Upon failover the network name and IP are ubound from the current active node and transferred\bound to the failover partner. The storage layer is also transferred to the new partner and all resources are brought online in a defined order, which is as follows

    first

    storage

    virtual IP

    second

    virtual network name

    third

    SQL server service

    fourth

    SQL server agent service

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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