SQL server memory won't release 
Author Message
 SQL server memory won't release

Hi and thank you for looking

Here's my problem:  we have SQL server 7.0 running on a Dell server, with
1GB of ram.  Lately, some consultants began to install reports available
through our intranet by using synergy and cold fusion.  They did complex
reports that used many queries at a time.  However it seems that whenever
they run a nested query or many queries to display a report, the memory used
by the server is not released.

If I am looking at the task manager, I can see that whenever they execute a
report, the memory goes up, sometimes some of it is released but not always.

The server has 1GB of memory, and in the SQL server settings I changed the
'available memory to use' to max 800 mb, but it still doesn't release it
after.  The transaction log is set at 750 mb, but if I look at it it's not
even one third in use, and the option 'truncate log on checkpoint' is
checked.

We are now at a point where we must reboot the server several times a day,
and it is becoming quite frustrating.  Is there any setting or temporary
tables we could change ?


Thank you for your time,
Simon



Tue, 23 Apr 2002 03:00:00 GMT
 SQL server memory won't release

Do you have SP1 installed?

--
All opinions expressed here are mine and mine alone

-----------
Show support for SQL Server and support the American Red Cross, order your
books from barnesandnoble.com at
http://bn.bfast.com/bfast/click/mid1349732?siteid=6710312&bfpage=h



Quote:

> Hi and thank you for looking

> Here's my problem:  we have SQL server 7.0 running on a Dell server, with
> 1GB of ram.  Lately, some consultants began to install reports available
> through our intranet by using synergy and cold fusion.  They did complex
> reports that used many queries at a time.  However it seems that whenever
> they run a nested query or many queries to display a report, the memory
used
> by the server is not released.

> If I am looking at the task manager, I can see that whenever they execute
a
> report, the memory goes up, sometimes some of it is released but not
always.

> The server has 1GB of memory, and in the SQL server settings I changed the
> 'available memory to use' to max 800 mb, but it still doesn't release it
> after.  The transaction log is set at 750 mb, but if I look at it it's not
> even one third in use, and the option 'truncate log on checkpoint' is
> checked.

> We are now at a point where we must reboot the server several times a day,
> and it is becoming quite frustrating.  Is there any setting or temporary
> tables we could change ?


> Thank you for your time,
> Simon



Tue, 23 Apr 2002 03:00:00 GMT
 SQL server memory won't release
I have service pak 1 installed and I have the same trouble.  I found a
quicker (temporary) fix than rebooting my server.  If you stop and then
re-start the service you will free up the memory that is being used.

I would also like to know a permenant fix.  Any ideas?

Brad


Quote:
> Do you have SP1 installed?

> --
> All opinions expressed here are mine and mine alone

> -----------
> Show support for SQL Server and support the American Red Cross, order your
> books from barnesandnoble.com at
> http://bn.bfast.com/bfast/click/mid1349732?siteid=6710312&bfpage=h



> > Hi and thank you for looking

> > Here's my problem:  we have SQL server 7.0 running on a Dell server,
with
> > 1GB of ram.  Lately, some consultants began to install reports available
> > through our intranet by using synergy and cold fusion.  They did complex
> > reports that used many queries at a time.  However it seems that
whenever
> > they run a nested query or many queries to display a report, the memory
> used
> > by the server is not released.

> > If I am looking at the task manager, I can see that whenever they
execute
> a
> > report, the memory goes up, sometimes some of it is released but not
> always.

> > The server has 1GB of memory, and in the SQL server settings I changed
the
> > 'available memory to use' to max 800 mb, but it still doesn't release it
> > after.  The transaction log is set at 750 mb, but if I look at it it's
not
> > even one third in use, and the option 'truncate log on checkpoint' is
> > checked.

> > We are now at a point where we must reboot the server several times a
day,
> > and it is becoming quite frustrating.  Is there any setting or temporary
> > tables we could change ?


> > Thank you for your time,
> > Simon



Wed, 24 Apr 2002 03:00:00 GMT
 SQL server memory won't release
SQL Server will not release the memory immediately because it thinks that
you need the data loaded into memory buffers (and you do as you have just
run a report on this data).  SQL Server does not know (and cannot know) that
you are now finished with data and that it should be written back to disk
and memory released.  This data will remain in the buffers, as all data
remains in the buffers, until SQL Server needs to swap it out for new data
or another program is started on the NT Server that needs memory.  SQL
Server will then release as much as it can from its allocation if the data
those memory buffers have not be referenced for sometime.

--



Wed, 24 Apr 2002 03:00:00 GMT
 SQL server memory won't release
Wile - SQL Server will only release the memory if there is a request for
memory from additional applications that exceed 5mb +/- 200kb to prevent NT
paging.  Adjust the max memory setting if necessary.

--
HTH
--
Jerry Spivey
MCT, MCSE, MCSD
Senior SQL Instructor - Consultant
ARIS Corporation  Bellevue, WA
(Please reply to the newsgroup only, not by email.)



Quote:

> Hi and thank you for looking

> Here's my problem:  we have SQL server 7.0 running on a Dell server, with
> 1GB of ram.  Lately, some consultants began to install reports available
> through our intranet by using synergy and cold fusion.  They did complex
> reports that used many queries at a time.  However it seems that whenever
> they run a nested query or many queries to display a report, the memory
used
> by the server is not released.

> If I am looking at the task manager, I can see that whenever they execute
a
> report, the memory goes up, sometimes some of it is released but not
always.

> The server has 1GB of memory, and in the SQL server settings I changed the
> 'available memory to use' to max 800 mb, but it still doesn't release it
> after.  The transaction log is set at 750 mb, but if I look at it it's not
> even one third in use, and the option 'truncate log on checkpoint' is
> checked.

> We are now at a point where we must reboot the server several times a day,
> and it is becoming quite frustrating.  Is there any setting or temporary
> tables we could change ?


> Thank you for your time,
> Simon



Wed, 24 Apr 2002 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. SQL Server don't release memory

2. SQL Server doesn't release memory

3. SQL Server doesn't release memory

4. SQL Server 6.0 won't start - changed memory config

5. NT Developer server won't release .fmx

6. SQL Server won't start on server with multiple IP's

7. Confingured too much memory, server won't start

8. BCP takes lot's of memory and doesn't release it

9. Upgrade to win xp and ms sql server won't start

10. SQL Server release 'Yukon'

11. ADO Not releasing memory on SQL Server 2000

12. SQL Server 7 releasing memory?


 
Powered by phpBB® Forum Software