SQL Server Performance

Memory Configuration

Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by contactjimmyus, Aug 8, 2008.

  1. If i have a 32 bit system with 13 gb RAM. I enabled 3gb switch in boot .ini.
    So how much meory sql can use ,is it only 3GB. The kernal can use only 1 gb.The rest of the ram is not recognized by os.Please explain the details
    Thanks a lot
  2. preethi Member

    /3GB switch is useful only when you have 4GB or less of memory. Normally, OS tries to take 2GB of memory and balance 2GB is given to SQL Server. /3GB switch adjusts that boundary. but the total memory available (under OS) is still limited to 4GBTo access more than 4 GB of memory You need to use AWE. Please read this article: http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx

Share This Page