Enabling AWE (Address Windowing Extensions) in SQL 2005

In Microsoft SQL Server 2005, you can use the Address Windowing Extensions (AWE) API to provide access to physical memory in excess of the limits set on configured virtual memory.

The specific amount of memory you can use depends on hardware configuration and operating system support.

By default SQL AWE setting is disabled, and need to be set following parameters to achieve this.

01) Windows Boot.ini configuration
/PAE (boot.ini)

02) Enable the Lock Pages in Memory Option (Windows)
Add SQL Service Account to "Enable the Lock Pages in memory" in Group Policy (Local)

03) SQL Configuration needs to be done in sp_configure

'AWE enabled' (sp_configure)
'max server memory' (sp_configure)
'min server memory' (sp_configure)

Read more: http://msdn.microsoft.com/en-us/library/ms189631.aspx; http://msdn.microsoft.com/en-us/library/ms190673.aspx

-Thanks
@Roshan