sql server clustering: Estimating cluster memory requirement -- sql server clustering

Re: Estimating cluster memory requirement

Siddhartha Jain
11/22/2005 12:00:00 AM

Thanks for the reply Geoff. I don't intend to run multiple instances per
node but only one instance per node. So lets say I have six servers now,
each using 2GB currently for the SQL server instance, then do I size 6GB
for the SQL instance per cluster node (in a cluster of two nodes).

- Siddhartha

[quoted text, click to view]

Re: Estimating cluster memory requirement

Geoff N. Hiten
11/22/2005 8:36:43 AM

It actually works the other way around. Put as much memory as you can in
each node. SQL will generally run better the more memory you give it. Then
divide the memory amongst the instances. Remember, during a failover, all
your instances will "stack" onto one server so you must plan for that
situation. Also you will need to leave 1-2GB for the OS and support
applications. Use the Performance Monitor tool to watchoverall memory use.
I like to use Page Life Expectancy as a measurement for memory pressure
within SQL Server.

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

[quoted text, click to view]

Re: Estimating cluster memory requirement

Geoff N. Hiten
11/22/2005 9:07:16 AM

During a cluster node failure event, the instances will all migrate to a
single node. That is how it wirks. You will need to divide the memory so
that both instances can live on a single node. As for total memory
required, there is no exact rule. SQL likes more memory so adding memory
won't hurt. Watch the performance counters to check memory pressure.

GNH

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server clustering group.