sqlservr process sucking memory

Tech-Archive recommends: Fix windows errors by optimizing your registry

Howdy,

I have MSDE 2000 running on my WinXP Pro SP2 workstation and its only
running one database for my local intranet. I am the only one accessing the
page and at most it loads about 60 links, very lightweight app. The process
sqlservr is at 113MB of mem usage and 123MB of virtual memory. Why? If I
stop SQL and restart it it drops to about 20MB but then climbs back up and
keeps going! What is causing it to get so large? Again, its such a small
lightweight database.
My development server, MSSQL2000 on Win2k3 Standard, has more databases and
is hit by more users. There are two instances of sqlservr totaling 120MB.
One of my customer's production machines, MSSQL2000 on Win2k3 SBS Premium,
has 4 instances of sqlservr totaling 300MB mem and 340MB virtual.

Now with all that said, is there anything that can be done to reduce the mem
usage on my workstation, development box and even the production box? The
production box isnt too bad, but my workstation could use a break. I usually
operate around 1.6GB memory and 2.5GB virtual. I'm just trying to reduce
some items to gain performance.

Thanks for your time!

--
David Lozzi
Web Applications Developer
dlozzi@(remove-this)delphi-ts.com




.

Relevant Pages

  • Oracle DBA, Denver, Branta Group Contract
    ... Oracle DBA, Denver, Branta Group Contract ... sites focusing on database performance and availability. ... first and second tier resolution of production issues. ... procedures supporting a mission critical 24x7 production environment ...
    (comp.databases.oracle.marketplace)
  • Oracle DBA, San Jose, Branta Group Contract
    ... Oracle DBA, San Jose, Branta Group Contract ... sites focusing on database performance and availability. ... first and second tier resolution of production issues. ... procedures supporting a mission critical 24x7 production environment ...
    (comp.databases.oracle.marketplace)
  • Re: Refresh Problem
    ... Locking/Unlocking Workstation: ... Set the database field RWUser to the user's ID for locking, ... window does not update every time. ... refresh does what it is supposed to do. ...
    (microsoft.public.fox.programmer.exchange)
  • RE: WMI and Joining Domain (sysprep related)
    ... If you have a database of info like the MAC, Serial, Computer name, domain, ... I have vbscript examples for renaming the workstation and can manually ...
    (microsoft.public.scripting.vbscript)
  • Looking for a few good beta testers
    ... development off-line and install it in the production environment after ... If so, you need ZZ DoesIt!! ... DefaultValue, Required, AllowZeroLength) will be flagged as Install: ... Tables in the From database which don't exist in the To database ...
    (microsoft.public.access.modulesdaovba)