Francisco H Tapia
my.lists at verizon.net
Thu Feb 6 15:00:53 CST 2003
what patch level are you at?, IMHO you should have it up to SP2 at least (if not SP3, because of the slammer worm). Next check if you are using FixedMemory allocation or dynamic. -Francisco http://rcm.netfirms.com ----- Original Message ----- From: "Billy Pang" <tuxedo_man at hotmail.com> To: <dba-sqlserver at databaseadvisors.com> Sent: Thursday, February 06, 2003 11:50 AM Subject: Re: [dba-SQLServer]SQL2K memory usage : 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 : : _______________________________________________ : dba-SQLServer mailing list : dba-SQLServer at databaseadvisors.com : http://databaseadvisors.com/mailman/listinfo/dba-sqlserver : http://www.databaseadvisors.com :