June 26, 2002 at 6:27 am
hello everyone. after exhausting all reading material on multiple instances of sql 2k on a cluster I wanted to run my config by anyone that would listen to determine if I got it right. I have a 2 node active/active cluster with 6GB ram on each node. this is a dedicated sql cluster and each instance on each node will run one db. from what i've read I need to update boot.ini on each node with the /3GB and /PAE switch and then make sure that the sum of the max server memory for each node (in case of failover) does not exceed the physical ram in either of the 2 nodes. That being said I would think it would be safe to give each instance on each node 2.5GB as a max server memory. If one node fails that would mean the other would run 2 instances @ 5GB total leaving 1GB for server processes and managing AWE. Do you think this config is a good starting point. I have not tested it yet but will start next week. thanks in advance for any comments or suggestions. Again this cluster is dedicated SQL only. not other apps.
June 26, 2002 at 2:17 pm
Looks like a good config to me.
I don't think you will need the /3GB switch in there with the /PAE switch.
I know that I don't need it with my 8GB servers and I'm able to allocate above the 3GB mark without any issues.
Make sure you do alot of failover testing, also, regrouping items in the Cluster Admin will make a big difference too.
For my setup I changed alot of the items in cluster admin so that they wouldn't cause the system to failover if they were down... for example if SQL Agent crashes I don't want my cluster to failover.
June 26, 2002 at 2:41 pm
THANKS DAN. IF YOU CAN THINK OF ANYTHING ELSE PLEASE LET ME KNOW..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply