Eric -
What's the behavior when it runs out of locks?
Regards.
-Bill
www.brainbox.tv
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, July 25, 2001 1:27 PM
Subject: RE: SQL Server memory use grows
>
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
