Re: Seems like only 1GB RAM being used even when higher MAX RAM is

Hi Larry,
Thank you for your detail response for clarifying the issue.

So your real concern is that your SQL Server can only consume maximum 1069MB physical memory on your server that has actually 4GB memory, though you had configured your SQL Server to
use minimum 2GB memory. Your expectation is to have your SQL Server use almost 2GB memory.
If I have misunderstood, please let me know.

By design, Windows OS will cover 2GB memory for system use and the left 2GB memory is for all Windows applications. SQL Server is one of those applications and it should be normal that it
cannot utilize the maximum 2GB memory since other applications or services will also consume some memory. Could you please check how much memory is used other applications running on
your server?

If there are some heavy load T-SQL queries, I recommend that you enable /3GB switch in the Boot.ini file on your Windows Server, for example:
[Operating Systems]
multi(0)disk(0)rdisk(0)partition(2)\WINNT="Microsoft Windows Server 2003" /fastdetect /3GB

In this case, Windows OS will keep 1GB for OS and leave 3GB for user mode applications. After that configure your SQL Server minimum memory to 2GB.

Hope this helps.

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================




.

Relevant Pages

  • Re: FTS Performance in SQL 2005
    ... we had no end of problems with SQL FTS. ... Looking for a SQL Server replication book? ... The Memory Usage and VM Size never increase over about 65 MB and 20MB. ... cost relative to the whole batch, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: System information
    ... > Available Physical Memory: 66.83MB ... is not enough for most applications today I ... Virtual memory includes part of your hard drive (space on your hard disk ... No - Windows and most other applications will use as much memory as you will ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: FTS Performance in SQL 2005
    ... we had no end of problems with SQL FTS. ... Looking for a SQL Server replication book? ... The Memory Usage and VM Size never increase over about 65 MB and 20MB. ... cost relative to the whole batch, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: 16-bit Applications
    ... I don't know what it's called, looks like a batch file icon ... If clicking the Advanced button on the Program tab shows Windows PIF ... WOW Environment Remains in Memory After Quitting 16-Bit Program ... >> about 32-bit applications other than the fact they can address more ...
    (microsoft.public.windowsxp.general)
  • Re: 1G vs. 512 - noticeable performance difference?
    ... >boot up, program opening, multi-tasking works on several applications. ... Adding more memory can noticeably improve performance only if the ... Unfortunately there is no ready way of determing actual paging file ... usage provided with Windows XP - it does not have an equivalent to the ...
    (microsoft.public.windowsxp.hardware)