> Ok here's the deal. I run a TON of Cold Fusion apps on our site,
> and running SQL Server 7.0.
> I am still learning SQL Server but here is whats happening. Over
> time the RAM usage for SQL Server goes up and up, and continues
> to until I stop and restart the service then it drops back down.
> Obviously there is some type of memory leak and I dont know where
> to begin to trouble shoot. Meaning are there some settings on the
> Datasources I should change to prevent this or is it something in
> SQL Server I need to look at.
> If anyone has experience with this please respond.
Actually, this isn't a memory leak - SQL Server takes all of the memory it
needs to cache the queries and handle it's pending jobs
You can restrict the amount of RAM that SQL Server will use, but ideally, it
should be on it's own machine with (a minimum of) 512Mb RAM.
If you want to stop limit the memory of SQL Server, right click on the
Server name (in Enterprise Manager) and choose Properties - then into the
Memory tab - you will then see the sliders for the amount of RAM you can set
SQL Server to use
If you're running your CF/SQL machine with less than 256Mb RAM, then
UPGRADE! SQL Server loves memory, and uses all it can...
HTH
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
