SQL Server Performance

Server Memory limits

Discussion in 'Performance Tuning for Hardware Configurations' started by rweinstein, Jan 11, 2005.

  1. rweinstein New Member

    Hi,

    I just installed more memory into my Windows 2000 Professional Server and am up to 6GB. It shows as such on the boot up screen.

    However, when you go into task manager and look at the total memory of the system, it is 3.7GB.

    After the install, my network team researched and found the following article:

    &lthttp://www.microsoft.com/whdc/system/platform/server/PAE/PAEmem.mspx>

    Apparently, the limit for my server is 4GB.

    Why is there only 3.7 showing in task manager and not 4GB, and does anyone know what I can do to get the server to use more memory, al least the full 4GB?

    Thanks.
  2. Luis Martin Moderator

    1) What kind of SQL do yo have?
    2) What memory configuration did you set on SQL Properties?

    I don`t remember how much memory SQL can reach with Windows Professional, but with SQL Standart you only can get 2GB, with SQL Enterprise 8GB, but I can`t image SQL Enterprise on Windows 2k Professional.

    Also task manager is not the best tool to see that. Use Peformance Monitor --> SQL Memory Manager --> Total SQL Memory.

    Also checkhttp://www.microsoft.com/windows2000/professional/evaluation/features/default.asp


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  3. satya Moderator

    I think it is Windows 2000 Advanced server not a Win 2K professional system.
    Do not go by the figures from Task Manager, get the PERFMON(SYSMON) counters for Memory, cpu, SQL Memory for further assessment.

    Refer to this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech for further information on configuring memory more than 2GB.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. rweinstein New Member

    Thanks for the replies. This server is my load balancing server and does not have the SQL database. I will be upgrading the memory in the SQL database server tomorrow and will want to raise the limit of SQL to 2 GB. We have SQL standard edition, not enterprise. I am using Perf mon and will check the new stats to see what is up and will look into thise articles.

    Thanks.

Share This Page