I have turned on AWE and set my limit from 0-6Gigs. Still I top out of 3.8 gigs.
If this is a 64 bit machine, what did you turn on AWE?
How did you "set your limit"? Did you use sp_configure?
sp_configure 'max server memory' XXXXX
RECONFIGURE
How are you determining that it's using 3.8 GB? Task Manager?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/