March 10, 2005 at 11:54 am
I have a A/P cluster setup with node 1 being the primary node. a 2nd instance of sql is installed on 2nd node . Currently node 1 is online and below are the system details. My question is what are the configuration setting that needs to be changed before node 2 is up and running . My priority is availablity of the nodes than performance if i failover from 1 to 2 or vice versa with 2nd instance also running. any help will be greatly appreciated.
TIA
As i said its an active/passive cluster
System details on Node 1 are
- 8 Processors with 3GHz
- Total Physical Memory = 8,289,320 KB
- Available Physical Memory = 523504 KB
- Total Virtual Memory = 18,483,688 KB
- Available Virtual Memory = 2,888,536 KB
- Page File Space = 10,194,368 KB
System detail on Node 2 are
- Total Physical memory = 8,129,320 KB
- Available Physical memory = 7,626,308 KB
- Total Virtual Memory = 18,484,176 KB
- Available Virtual Memory = 17,292,940 KB
- Page File Space = 10,194,368 KB
My second instance is on Node2 . What should i consider/change so that
there isnt a bad impacted when 2nd instance is up and running and if things
failover from node 1 to Node2.
March 10, 2005 at 8:46 pm
It will largely depend on how much memory you would like to give to Node-2. From the settings above, it seems that you have awe enabled on instance 1 and disabled on instance 2. Hence, instance 2 will only use upto 2 GB virtual address space. Your instance 1 will still use the additional memory when failed over. I think you can leave the settings for instance 2 at its default or lower the max. memory settings to around 1 gig if you are not using it extensively. Regarding instance 1, please note that you change the value for max server memory to probably 6144 from the default.
March 11, 2005 at 1:42 pm
I dont have awe enabled on node 1. The 2nd instance of sql is installed only coupel of days ago so has only teh system database nothing else running on that. But once its heavily used my concern would be if there s afilover on node 1 will node 2 be able to handle teh existing databases and all thats on node 1. any help ??
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply