Memory Allocation

  • Hi,

    Let's describe the environment:

    3 cluster nodes (active-active)

    Memory on each node is 64 gig.

    Windows Server 2003 R2 Enterprise x64 SP2

    How the memory allocation will be on each node (64 gig or 64/3, I assume each node has one SQL Server Instance)

    Regards,

    Ahmed

  • It depends. Do you need every clustered instance to work the same if there is a failover? If so, then 64/3 makes sense. If you assume failovers are rare and can live with slightly lower performance, I'd go with 32 on each server and assume that you'll never have more than 1 failure. Or you could assign more and just have less resources for the failed instance.

  • Thanks Steve,

    I have just another concern, if we add new instances on each node, so the memory on each node will be shared between instances I think so.

    Ahmed

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

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