Davidson"To: CF-Talk <[EMAIL PROTECTED]>
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
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
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
mbeat.com>cc:
Subject: Re: SQL Server memory use
grows
Subject: RE: SQL Server memory use grows
07/25/2001
> 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
>
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
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
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
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
11 matches
Mail list logo