SQL Server Performance

4GB memory avaliable in EM without /3GB Switch

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by timo, Dec 17, 2007.

  1. timo New Member

    SQL 2000 Enterprise manager allows me to set max memory usage to 4GB on a Windows Server 2003 R2 with 4GB of physical RAM, yet i have not added the /3GB switch to boot.ini. I was expecting the OS to reserve the upper 2GB and hence EM to limit me to 2GB until i edited the boot.ini file and rebooted. So is EM wrong or is the /3GB switch in some way optional?
  2. satya Moderator

    Welcome to the forum!
    You need to apply the /3gb switch on Windows 2003 (I think) and what is the edition of the SQL Server used here?
    By defautl the STandard edition will not be able to go beyond 2gb in this case, for Enterprsie edition it will be assigned as dependant on the operating system.
    For memory counters you should depend upon SYSMON (PERFMON) and not on Task Manager or Enterprise Manager.

Share This Page