32bit SQL 2005 on x64 Windows EE | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

32bit SQL 2005 on x64 Windows EE

If running SQL Server 2005 32 bit on a 64 bit Windows 2003 OS with 8GB of
RAM, what needs to be done to allow SQL Server to address memory above 2GB?
From my reading in BOL I thought we needed to enabling AWE in SQL Server
Management Studio and grant the startup account for the SQL Service the
ability to "lock pages in memory". Is this correct?? My Windows Admins are
saying this is incorrect? I’m also under the impression that the 3GB switch is no longer necesary because of WOW64. Thanks

on the lock pages in memory matter,
this sounds reasonable
is not one of the new features in 2005 non-static allocation of memory for AWE,
try it and find out the /3GB can still be helpful,
even thoug the OS is 64-bit, the application virtual address split is still 2/2, so changing this to 3/1 is still helpful
]]>