[dba-SQLServer]SQL2K memory usage

You can check for sure by using SQL profiler, and monitoring the memory
usage, also performance monitor so you can see what processes are running on
the computer... you may also need to check if your server is set up for
dynamic memory usage or fixed, if the latter then of course that's why it
takes up all 700mb, but if it is dynamic memory usage it ought to release
memory whenever nothing is running and the OS demands it.  Double check your
memory configuration by going to EM and right clicking on your server then
properties.

-Francisco
http://rcm.netfirms.com
----- Original Message -----
From: "Stephen Hait" <shait at mindspring.com>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Wednesday, February 05, 2003 4:32 PM
Subject: [dba-SQLServer]SQL2K memory usage


: Any ideas why SQL2K would utilize 10-12Mb when initially
: started but then spike up to over 700Mb when there is nothing I
: know of accessing the database? Enterprise manager is not
: running, SQL Server Agent is not running. Stopping then
: restarting returns memory usage to the initial levels.
:
: Regards,
: Stephen