May 5, 2009 at 8:12 am
So I did everything to enable AWE on one of our SQL 2005 32 bit machines. It has 8 gigs of memory.
/PAE switch is in. Permissions for page locking etc.
The error log confirmed AWE was enabled.
So I set min to 2048 and max to 6144. When I run a select on the counters for Total and Target server memory I still see about 1.5 gigs for both.
What gives? Shouldnt target server memory be at 6 gigs?
May 5, 2009 at 8:35 am
Hi,
When you say that you did everything to enable AWE, what 'exactly' did you do?
Some quick points that may assist you.
1.Have you restarted the SQL Server Service since making the changes?
2.When enabled, a message will be placed in the SQL Server Log File that reads:
"Address Windowing Extensions is enabled. This is an informational message only; no user action is required."
Cheers,
May 5, 2009 at 8:39 am
John Sansom (5/5/2009)
Hi,When you say that you did everything to enable AWE, what 'exactly' did you do?
Some quick points that may assist you.
1.Have you restarted the SQL Server Service since making the changes?
2.When enabled, a message will be placed in the SQL Server Log File that reads:
"Address Windowing Extensions is enabled. This is an informational message only; no user action is required."
Cheers,
Yep that line was in the log. I restarted the service after making the change. Am I wrong to expect to see 6 gigs in the Target server memory counter at this point?
May 5, 2009 at 9:03 am
Fixed it. I rebooted the machine again. Seems like you need to make sure you rebeeot after setting the lock pages permission.
May 5, 2009 at 9:19 am
SQL Server does not automatically allocate the minimum or maximum memory when it starts. It allocates the memory as it is needed. Once it reaches the minimum amount - SQL Server will not release that amount back to the OS.
SQL Server will not allocate memory above the maximum value for the buffer pool. Note, that does not mean SQL Server does not use more than the maximum value - which it will - it just does not allocate more to the buffer pool.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply