RE: SQL Server memory use grows

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

RE: SQL Server memory use grows

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

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 ago,

RE: SQL Server memory use grows

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

Re: SQL Server memory use grows

2001-07-25 Thread eric . laney
] mbeat.comcc: Subject: Re: SQL Server memory use grows 07/25/2001 01:22

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. There is a specified amount used by SQL

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 Server.

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 SQL Server 7.0 box has 512MB and does

Re: SQL Server memory use grows

2001-07-25 Thread eric . laney
To: CF-Talk [EMAIL PROTECTED] bill@intragecc: t.com Subject: Re: SQL Server memory use grows