SQL Server Performance

Memory allocation / 3 GB Switch

Discussion in 'Performance Tuning for Hardware Configurations' started by sajid107, Aug 25, 2005.

  1. sajid107 New Member

    Hi All,

    I am looking for some guidelines on how to best configure SQL server for performance. In particular, I am interested in understanding how much memory to allocate to the db application itself (using AWE to prevent disk swapping) - for example, if a box has 8GB of physical memory, how much should be allocated to MSSQL vs. what's reserved for the OS/any other applications that might be running on the box (Windows 2000 Advanced Server/Windows 2000 Professional Edition/Windows 2000 Server/Windows Server 2003)?

    I am also interested in understanding the impact of using the /3GB switch on SQL performance.

    Thanks in advance

    Sajid
    sajid107, Aug 25, 2005
    #2

  2. bradmcgehee New Member

    bradmcgehee, Aug 25, 2005
    #2

  3. satya Moderator

    satya, Aug 25, 2005
    #2

Share This Page