We have a Sql Server running Server 2003 Std X64 SP2, On this we have a Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86).
This Server has 12 gigs of ram in it right now, Sql is using about 3.8 of that and I want it to take more as I have 7 gigs doing nothing. I have turned on AWE and set my limit from 0-6Gigs. Still I top out of 3.8 gigs.
I have turned on lock pages in memory but I am not sure if it is actually doing anything. I just used a Domain admin account as a Test maybe I need a different account.
Am I missing something or is this sort of how it is.