My SQL Server 7.0 box has 512MB and does nothing but SQL. The last time I
rebooted it to do a hotfix, it was running with over 400MB of RAM dedicated
to SQL Server. The only problem I run into is when I get a big spike of
activity and the server runs out of Locks. I'll be moving my Client
variable data store to a different SQL server soon, which should alleviate
that problem.
In short, I don't think 140MB is anywhere close to being a problem.
|-----------------------------+-------------------------------------------|
|Eric A. Laney |The closed mouth swallows no flies. |
|Systems Engineer | |
|LAN Optimization Team | |
|Voice: 813.978.4404 | - Spanish proverb|
|Pager: 888.985.8519 | |
|-----------------------------+-------------------------------------------|
"John Fix 3rd"
<john3list@cor To: CF-Talk <[EMAIL PROTECTED]>
nells.com> cc:
Subject: RE: SQL Server memory use grows
07/25/2001
12:31 PM
Please respond
to cf-talk
There's 512mb installed right now. OK, if that doesn't seem out of
line, then I'll leave it for a longer period next time and see what
happens.
Thanks!
John
> -----Original Message-----
> From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 25, 2001 10:46 AM
> To: CF-Talk
> Subject: RE: SQL Server memory use grows
>
>
> 140MB? that sounds like SQL, not a memory leak. you can
> restrict the amount of memory (or range thereof) SQL uses.
> how much RAM is on your SQL server? it really shouldn't be
> less than 512MB and ideally, 1GB+.
>
> -----Original Message-----
> From: John Fix 3rd [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 25, 2001 7:27 AM
> To: CF-Talk
> Subject: SQL Server memory use grows
>
>
> I finally moved some of our Cold Fusion Access databases to
> SQL Server 7 on a separate server. Things are running well,
> but I notice that over several days SQL uses more and more
> memory. It starts at about 40mb but is now running at about
> 90mb. When I restarted the service a few days ago, it was up
> to about 140mb. Sounds like a memory leak somewhere, but I
> need some ideas where to look.
>
> Thanks!
>
> John
> www.cornells.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
