[dba-SQLServer]SQL2K memory usage

Billy Pang tuxedo_man at hotmail.com
Thu Feb 6 13:50:48 CST 2003


This happens to SS2K on my machine as well..
I would like to know why...
I am absolutely sure there are nobody accessing the db.  Then for apparently 
no reason whatsoever, SS2K will demand for more resources...

Billy


>From: "Francisco H Tapia" <my.lists at verizon.net>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: Re: [dba-SQLServer]SQL2K memory usage
>Date: Wed, 5 Feb 2003 16:41:30 -0800
>
>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
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com


_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*   
http://join.msn.com/?page=features/junkmail




More information about the dba-SQLServer mailing list