Microsoft SQL Server is a data-intensive and disk I/O (read and write) intensive database management system. SQL Server running on systems with a large amount of physical RAM memory (8 GB or more) can be configured to use the Address Windowing Extensions (AWE) API to provide access to physical memory in excess of the limits set on configured virtual memory, and force all paging to take place in memory for faster data and thread access.
With the Address Windowing Extensions (AWE) API, Microsoft SQL Server can support and access very large amounts of physical memory, upwards of 64 gigabytes or more on Windows 2000 Server, Windows Server 2003 and Windows Server 2008 (R2). The specific amount of memory SQL Server can use depends on hardware configuration and operating system support.
Before enabling AWE, Lock Pages in Memory permission must be granted to the user account that runs SQL Server as AWE memory cannot be swapped out to the page file. Note that AWE is not required for 64-bit systems, but the Lock Pages in Memory privilege is recommended for 64-bit systems.
Step 1: Enable PAE support on Windows Server to allow large segment of physical memory to be used. Continue reading “Optimize SQL Server 2005/8 in Large RAM Systems with AWE”