Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Memory Allocation Expand / Collapse
Author
Message
Posted Tuesday, September 16, 2008 11:26 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 12:42 PM
Points: 1,326, Visits: 1,282
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
Post #570482
Posted Tuesday, September 16, 2008 1:46 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 33,088, Visits: 15,197
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.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #570578
Posted Wednesday, September 17, 2008 8:13 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 12:42 PM
Points: 1,326, Visits: 1,282
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
Post #571030
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse