Memory Allocation

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Memory Allocation

Memory Allocation

Rate Topic

Display Mode

Topic Options

Author

Message

SQL_ABD

Posted Tuesday, September 16, 2008 11:26 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, February 15, 2013 6:29 PM
Points: 1,326, Visits: 1,265

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

Steve Jones - SSC Editor

Posted Tuesday, September 16, 2008 1:46 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436, Visits: 13,751

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

SQL_ABD

Posted Wednesday, September 17, 2008 8:13 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, February 15, 2013 6:29 PM
Points: 1,326, Visits: 1,265

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 »

Permissions