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

I'm following this thread and the problem is really interesting.

However, in your following reply, I wish you'd tell us the "Total Server Memory" and "Target Server Memory" counters' results.

I know, you gave us lots of proves about the memory consumption. But the results of these counters would definitely prove you had enough RAM but SQL Server can't take advantage of it.

--
Ekrem Önsoy



"Larry Epn" <larryepn@xxxxxxxxxxxxxxx> wrote in message news:2BD8FB94-7940-4707-A0FC-02CB9279BCCE@xxxxxxxxxxxxxxxx
Yes, it does not add up.
I just reconfirmed all of this.
Here is boot.ini:
--------------------------------------
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(2)\WINNT
[operating systems]
multi(0)disk(0)rdisk(0)partition(2)\WINNT="Microsoft Windows 2000 Server"
/fastdetect
--------------------------------------
Perfmon shows available MBytes = 2148
so 2Gb are just sitting there.

I made the changes you suggested (set min = 0, max = 2Gb), and restarted sql
service. I run a halacious join query and watch the memory increase,
increase,increase, and then in task manager it gets stuck at its usual
1062Mb, which is consistent with the PerfMon shows. Then in PerfMon, the
%Disk Time goes through the roof. This is what happens ALL the time,
regardless of what settings are changed.

Your suggestion to move to later versions is valid, but I don't see why I
can't get THIS server to use at least 2Gb (or 1.7Gb who's counting?) !!!

Does Microsoft have any ideas?

Thanks,
Larry

.

Relevant Pages

  • Re: A significant part of sql server process memory has been paged ou
    ... I spoke with the correct people at Microsoft about this at the PASS Summit a few weeks ago. ... No guarantees they will move the feature to Standard Edition, but they are now treating it as a stability issue rather than an scalability issue. ... We have just configured SQL Server 2005 64-bit two node active/passive ... Total Server Memory shows value 16MB at the moment. ...
    (microsoft.public.sqlserver.setup)
  • Re: Increasing Max Memory on second node of failover clusterring
    ... SQL Server Buffer Manager:Target Pages ... SQL Server Memory Manager:Target Server Memory ... On Windows Server 2003, this happens automatically whenever more than 4 ...
    (microsoft.public.sqlserver.clustering)
  • Re: (Target Server Memory)Perf. Monitor Counters
    ... What is the Total Server Memory counter value? ... I support the Professional Association for SQL Server ... > the SQL Server Memory Manager (Target Server Memory) value. ... > RECONFIGURE ...
    (microsoft.public.sqlserver.server)
  • Re: Killer scripts
    ... The 'min server memory' and 'max server memory' configuration settings can ... be used to restrict the amount of RAM available to SQL Server. ... > A script causing high CPU usage ... > A script causing high memory usage ...
    (microsoft.public.sqlserver.programming)
  • RE: Memory problem
    ... I guess that the SQL Server is configured to use Dynamic Memory ... SQL Server memory will continue to grow as long as there is no RAM pressure ... start to release memory for other applications use or to avoid swapping. ...
    (microsoft.public.sqlserver.msde)