AWE Did Not Work

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Travis - 30 Aug 2008 20:13 GMT

Hi ,

I turned on AWE and set a maximum to 28GB , but when I perform a select
statement , and found out the memory usage is extermely low

I tried to observe a AWE usage base on query below , it show 0.
SELECT
SUM(awe_allocated_kb) / 1024 as [AWE allocated, Mb]
FROM sys.dm_os_memory_clerks

Anything's goes wrong with window or sql server 2005 ?

I am using windows 2003 enterprise and sql server 2005 enterprise edition.

Thanks ,

Reply to this Message

Aaron Bertrand [SQL Server MVP] - 30 Aug 2008 20:25 GMT

Maybe your query did not require a lot of memory? Also remember that you
are dividing integers, so you will get 0 if the numerator is < the
denominator. See here for more information about validating AWE memory.
Task manager is NOT a good way, IMHO.

http://sqlblog.com/blogs/kevin_kline/archive/2008/08/29/sql-server-memory-tr
acking-with-windows-task-manager.aspx

On 8/30/08 3:13 PM, in article
B326CC4B-A4D1-4E5A-869C-051924DF5DC1@microsoft.com, "Travis"

> Hi ,
>
[quoted text clipped - 11 lines]
>
> Thanks ,

Reply to this Message