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

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: Perfmon
    ... (not perfmon) and added registry settings ... > these entries from the registry.. ... > performance monitor in windows. ... > 2003 server installation, without huge detriment to the server. ...
    (microsoft.public.win2000.registry)
  • Perfmon
    ... A windows 2003 server was infected by a virus, ... entries from the registry.. ... regarding "perfmon", which is the performance monitor in windows. ...
    (microsoft.public.win2000.registry)
  • Perfmon "Processor" Missing from "Performance object" Drop-Down Li
    ... I'm trying to use perfmon on MS Windows 2000 Server and I can't select the ... I have another Windows ... 2000 Server and it IS there. ... the counters after recording them. ...
    (microsoft.public.win32.programmer.kernel)
  • Re: CPU Usage
    ... Following up on the perfmon stuff... ... disk time is about 9% during selects. ... CPU Max is always 25.00 % ... the select run that never goes over 25% is in a stored procedure. ...
    (microsoft.public.sqlserver.server)
  • Running PerfMon as a Non-Admin
    ... Does anyone know how to allow a user to run perfmon on a Windows 2000 ... server without having admin rights to the server. ...
    (microsoft.public.windows.server.general)