Michael L John (4/14/2014)
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?
We turned it on via sql manager right click on the server and selecting properties. the Min to 0 Mb and the Max to 6144MB. We have restarted both
Yes I am checking Task manager.