SQL Server Performance

32bit SQL 2005 on x64 Windows EE

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by dtipton, Aug 30, 2006.

  1. dtipton New Member

    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.

  2. joechang New Member

    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

Share This Page