Hey Kelly,
SQL Server, I think by default is configured to use all the memory on the
machine. You can change this by going to Enterprise Manager, right click
on Properties (of your SQL Server, not the database) and then click on
Memory. From there you can configure SQL to have a MAX, MIN, or Fixed
memory size.
Aaron
-----Original Message-----
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 25, 2000 8:38 AM
To: CF-Talk
Subject: SQL Server Total Server Memory
Ok question. I have SQL server running on the same server as IIS
and CF. Basically we have a power house server and dont get a TON
of hits so saw no reason to have SQL on a separate server. I use it
only for some SMALL databases for the website. Now with SQL
server on the performance monitor you can monitor what's called
Total Server Memory. We have a gig of memory on the server however
here is whats happening. When I restart the MSSQLServer Service
it brings that Total Server memory down to about 9megs of that 1 gig.
However as the days pass that memory creeps up. For instance I checked
this morning and after 5 days it was using HALF of the 1 gig memory.
Obviously if i never restarted MSSQLServer at some point this would
end up using ALL of the servers memory. My guess is I am doing something
wrong
somewhere to cause a memory leak. Any suggestions either in how i write
my queries or how I set up SQL Server to prevent this?? Suggestions would
be appreciated.
Thanks
Kelly
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
