I have installed 16 gigs of ram in 2 servers that each house a virtual server\instance of SQL.
I have the /3gb sw and the /pae switch in the boot.ini and before failing over the group i ran the following script:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Instead of stopping sql server, I failed it over from node a to node b. This took a little while but worked fine.
I proceeded to add the memory allocation to use 6 gigs on the other node -b - and failed it over to node a.
After getting recovery complete for all my databases, I attempted to move my first instance back to node a - which failed and then on its own moved back to node b.
Please let me know if anyone has ran into this problem before and if I should change something etc.
Thanks,
Lenny
FAQ
Profile
Private Messages
Log in
