Configuring HP SIM for Optimal Performance in Large Environments

2
Lazy Writer ................................................................................................................................ 19
Log manager .............................................................................................................................. 19
Moving tempdb location ................................................................................................................. 20
SQL Server minimum and maximum memory ..................................................................................... 20
PAE and AWE ............................................................................................................................... 20
PAE .............................................................................................................................................. 21
User-mode address space on 32-bit x86 ........................................................................................ 21
Configuring Microsoft Windows Server 2008 x32 to use PAE .......................................................... 22
Using AWE memory in Microsoft SQL Server 2008 x32 to access more than 2 GB memory ................. 22
Microsoft SQL Server Express ....................................................................................................... 23
Configuring Microsoft SQL Server 2008 x32 to use AWE memory .................................................... 23
Using AWE memory .................................................................................................................... 24
For more information .......................................................................................................................... 25
Call to action .................................................................................................................................... 25