Re: SQL Server memory use grows

2001-07-25 Thread eric . laney
Davidson"To: CF-Talk <[EMAIL PROTECTED]>

Re: SQL Server memory use grows

2001-07-25 Thread Bill Davidson
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

Re: SQL Server memory use grows

2001-07-25 Thread tom muck
That's good to know. tom <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > According to Microsoft's documentation (for what that's worth) SQL Server > will not dynamically allocate memory if that allocation would cause > swapping. The OS might, but not SQL Se

RE: SQL Server memory use grows

2001-07-25 Thread John Fix 3rd
Cool...thanks for pointing that out! John > -Original Message- > From: tom muck [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 25, 2001 1:22 PM > To: CF-Talk > Subject: Re: SQL Server memory use grows > > > You shouldn't have to "wait and see

Re: SQL Server memory use grows

2001-07-25 Thread eric . laney
mbeat.com>cc: Subject: Re: SQL Server memory use grows

RE: SQL Server memory use grows

2001-07-25 Thread eric . laney
Subject: RE: SQL Server memory use grows 07/25/2001

RE: SQL Server memory use grows

2001-07-25 Thread Philip Arnold - ASP
> 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 >

Re: SQL Server memory use grows

2001-07-25 Thread tom muck
You shouldn't have to "wait and see". There is a specified amount used by SQL Server which you can find out by right-clicking on the server in the Enterprise Manager and then click the Memory tab. I think it's set to 768 megs by default as the max and 0 as the min. You can also specify a fixed a

RE: SQL Server memory use grows

2001-07-25 Thread John Fix 3rd
1 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 tha

RE: SQL Server memory use grows

2001-07-25 Thread Dylan Bromby
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 i

SQL Server memory use grows

2001-07-25 Thread John Fix 3rd
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 wa