We have a development server running windows server 2008 enterprise (x86) with SQL Server 2008 Developer (x86) installed.
The box has 8GB of ram installed, which windows sees. In order to get SQL Server to use memory above 2GB do I need to enable AWE or will it just pick it up automatically?
I found this article today which discusses in detail what AWE does. http://blogs.msdn.com/psssql/archive/2009/09/11/fun-with-locked-pages-awe-task-manager-and-the-working-set.aspx