November 21, 2014 at 1:00 am
Hi All,
We need to change max memory config for both active and passive nodes in sql server 2005 2 node cluster.
What are the correct steps to follow ? Kindly advise.
November 21, 2014 at 1:19 am
You don't have to change it in the passive node. Just change it in the active node and the setting will be preserved when you fail over the instance to the passive node.
To change max server memory:
EXEC sp_configure 'advanced', 1
RECONFIGURE
GO
EXEC sp_configure 'max server memory (MB)', 4096 -- this is 4GB, change it to an appropriate value
RECONFIGURE
GO
-- Gianluca Sartori
November 21, 2014 at 1:52 am
Thank you very much.!
So a failover is essential is it ?
We will failover and then faiolver back once again as we need the current node as active.
Thanks once again.
November 21, 2014 at 2:01 am
Joy Smith San (11/21/2014)
Thank you very much.!So a failover is essential is it ?
We will failover and then faiolver back once again as we need the current node as active.
Thanks once again.
No need to do that. Change it on the active node. Period.
It's a SQL Server setting that travels with the instance when you fail it over to the passive node.
-- Gianluca Sartori
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply