Post reply

Memory Allocation For An Active/Active Cluster.

  • October 27, 2010 at 3:43 am

    #230947

    Hello,

    I wondered if someone could answer a query I have regarding memory allocation in an Active/Active Cluster. If I have allocated a certain amount of RAM for four instances, let's say 4 GB each and 20Gb for the OS and the same on Node B, if the four instance on Node A failover to Node B, would each instance still use 4GB. I guess what I am asking is does the memory allocated to the four failed over instances still stand or does it change?

    As always, your advice and comments are appreciated.

    Regards,

    D.

  • October 27, 2010 at 4:49 am

    #1242760

    Yes the max memory SQL Server can take will be limited to the value you have specified, in your case 4 GB. Bear in mind though that the cache will be flushed on failover (as SQL Server is starting up on the other machine), so initial queries after a failover may be slow as SQL Server has to populate the buffer pool from disk as requests come in.

Viewing 2 posts - 1 through 1 (of 1 total)

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