• First of all you don't need AWE on 64-bit server http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-530-awe-must-be-enabled-on-64-bit-servers/. Second if you want it to take 7GB of memory then set the "min server memory" and it will take that amount of memory.

    Are you currently having memory pressure on your server? If not, why is it so important that you see the amount of memory get up to 7GB (i.e. your boss is questioning the amount of memory that the server really needs, etc).

    Please download the book and read it (at least the memory chapter).



    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]