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

Tech-Archive recommends: Speed Up your PC by fixing your registry

I made the changes you suggested (set min = 0, max = 2Gb), and restarted sql

Actually I said to put the max back at the default which is 2147483647. No tthat I think it is the problem but just wanted to eliminate it. If SQL is taking 1GB and there is 2GB left where is the other 1GB going? What does task manager say is using that other GB?

The only other thing I can think of is that someone set the -g startup option to a non-default value as well. If you look at the server properties in EM you can see the startup options. See if there is a -g and if so what the value is. If it is more than 256 you might want to question why and that will be the problem. If not I suggest you contact MS PSS so they can log into your system and have a look. Other than the AWE issue with SP4 I have not seen any bugs that would cause this behavior. Please let us know what you come up with.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"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: Perfmon logging to SQL database - slow retrieval
    ... place when you run perfmon and send it to a flat file instead of csv. ... Windows tool and supported by the Windows group, not the SQL group. ... They probably knew squat about SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2000 periodically running slowly
    ... perfmon will give a better indication as to how efficient your queries are ... running on the server other than SQL Server? ... amount of memory SQL Server can use by setting the MAX memory setting down ...
    (microsoft.public.sqlserver.connect)
  • Re: Performance Monitor / Database Storage using ODBC
    ... But yes MOM can collect Perfmon data and is designed to work across an enterprise so that should not be a problem. ... Andrew J. Kelly SQL MVP ... This solution would be just working temporarily (a few servers), ...
    (microsoft.public.sqlserver.tools)
  • Re: finding memory, cpu and io percentage
    ... to think about using profiler and perfmon to track you performance stats ... SQL 2000 Performance tuning tips ... >>> Is there a way to convert the numbers under memory, cpu and I/O usage into>> some kind of percentage or number of KB? ...
    (microsoft.public.sqlserver.server)
  • Re: Perfmon logging to SQL database - slow retrieval
    ... Thanks Andrew, I accept your point about right tool for the job, and I ... However I also find that using Relog to open data from SQL and output it to ... > efficient way if your going to use the Perfmon Gui to look at the data. ...
    (microsoft.public.sqlserver.server)