In addition to running the below queries:
Do we also need to configure the /3GB switch in the boot.ini file?
When do we enable AWE? before running these queries?
EXEC sp_configure 'show advanced options', '1'
RECONFIGURE WITH OVERRIDE
EXEC sp_configure 'min server memory', '0'
EXEC sp_configure 'max server memory', '3000'
RECONFIGURE WITH OVERRIDE
EXEC sp_configure 'show advanced options', '0'
RECONFIGURE WITH OVERRIDE
Thanks!