Hi everyone,
First, I know this question has been addressed in other posts. Maybe I'm thick but I'm still not clear on some things.
These are the specs:
Windows 2003 Enterprise SP1 32 bit
SQL Server 2005 Standard SP2
24 GB memory
SQL Server is configured to allocate memory dynamically.
The performance counters I have ran do NOT indicate a memory bottleneck.
However, a consultant has recommended that we make the following changes "to enable SQL Server 2005 Standard to be able to use > 3GB of memory if needed."
I thought it was not necessary to enable AWE if the OS is 2003 Enterprise but later found that only applies if it is 64 bit. I have 32 bit Enterprise.
In addition, another post indicates that I will only gain 1 additional Gig by enabled AWE (ie 4GB, not 3GB) but will not be able to use > 4GB. Is that correct?
Please review his suggestions (below) and reply back.
Thanks very much. John
Recommendation: This server has 24GB of memory available. In order for
SQL to access above the 3GB you need to enable AWE for the SQL server
Also Enable the Lock Pages in Memory Option – this is required to be able to
enable AWE on the SQL server. This is done through group policy for either the
local machine or group policy on an Organization Unit the server resides
within.
First, I know this question has been addressed in other posts. Maybe I'm thick but I'm still not clear on some things.
These are the specs:
Windows 2003 Enterprise SP1 32 bit
SQL Server 2005 Standard SP2
24 GB memory
SQL Server is configured to allocate memory dynamically.
The performance counters I have ran do NOT indicate a memory bottleneck.
However, a consultant has recommended that we make the following changes "to enable SQL Server 2005 Standard to be able to use > 3GB of memory if needed."
I thought it was not necessary to enable AWE if the OS is 2003 Enterprise but later found that only applies if it is 64 bit. I have 32 bit Enterprise.
In addition, another post indicates that I will only gain 1 additional Gig by enabled AWE (ie 4GB, not 3GB) but will not be able to use > 4GB. Is that correct?
Please review his suggestions (below) and reply back.
Thanks very much. John
Recommendation: This server has 24GB of memory available. In order for
SQL to access above the 3GB you need to enable AWE for the SQL server
Also Enable the Lock Pages in Memory Option – this is required to be able to
enable AWE on the SQL server. This is done through group policy for either the
local machine or group policy on an Organization Unit the server resides
within.