SQL SERVER – 2008 – High Availability – Hot Add Memory

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 (http://blog.SQLAuthority.com)

About these ads

One thought on “SQL SERVER – 2008 – High Availability – Hot Add Memory

  1. Pingback: SQL SERVER – Weekly Series – Memory Lane – #035 | Journey to SQL Authority with Pinal Dave

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s