Hi all, These are the specs: Windows 2003 Enterprise SP1 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. 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.