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.
