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