After reading my previous article about SQL SERVER – 2008 – High Availability – Hot Add CPU the same developer who suggested Hot Add CPU asked me if there are any restrictions in Hot Adding Memory.
Yes, there are few restictions to Hot Add Memory as well. I am listing them here.
1) Underlying hardware is always key concern. Hardware should be capable to add memory when previous memories are operational.
2) Operating system should be either Windows Server 2003 or 2008 Enterprise or Datacenter Edition.
3) This feature is only available in 64-bit SQL Server Enterprise Edition, or the 32-bit version with Address Windowing Extensions(AWE) enabled.
In summary, just like Hot Add CPU, Hot Add Memory have some restrictions but they are not as strict as Hot Add CPU.
Reference : Pinal Dave (https://blog.sqlauthority.com)