Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

growing memory consumption

4 posts in General Discussion Last posting was on 2004-10-29 13:09:27.0Z
jdyke Posted on 2004-10-28 20:19:57.0Z
From: jdyke <jdyke@azimapower.com>
User-Agent: Mozilla Thunderbird 0.7 (Windows/20040616)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: growing memory consumption
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 66.9.108.99
Message-ID: <41815468$1@forums-2-dub>
X-Original-Trace: 28 Oct 2004 13:19:52 -0700, 66.9.108.99
Lines: 29
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Oct 2004 13:19:54 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Oct 2004 13:19:57 -0700
X-Trace: forums-1-dub 1098994797 10.22.108.75 (28 Oct 2004 13:19:57 -0700)
X-Original-Trace: 28 Oct 2004 13:19:57 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3797
Article PK: 7692

I have a SQL Anywhere 9.01 installation on Windows2003 Small Business Server.
The memory consumption on this server seems to climb at an significant rate.

After a reboot dbsrv9.exe starts at about +-15mgs of memory and within a day it
is consuming over 140mgs. There are currently three databases on the server.

Reboot yesterday at 3pm (EST) (Memory started at 15mgs)
- DB1 - 3mgs - No growth since yesterday
- DB2 - 65mgs - 5 mgs of growth since yesterday
- DB3 - 203mgs - 40 mgs of growth since yesterday.
Current Memory at 4:10 EST is 145 mgs

The server is connected to from three seperate clients, two windows services and
a php script. The two remote servers insert data and the php scripts select
from it. No connections are persistant.

We have SQL anywhere on XP boxes for local development that don't take anyhwere
near this amount of memory(mine hovers at 24mgs) and also on a 2003 Standard
Server that hovers around 5-9 mgs at any given time.

So a question? do i have one? I'd like to know why dbsrv9.exe is consuming
memory like it is, and if there is anything that i can do about it.

Thanks for any ideas/comments you may have. I'm happy to provide additional
information as well.

Jeff


Greg Fenton Posted on 2004-10-28 23:35:24.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20040913)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: growing memory consumption
References: <41815468$1@forums-2-dub>
In-Reply-To: <41815468$1@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
Message-ID: <41818237@forums-2-dub>
X-Original-Trace: 28 Oct 2004 16:35:19 -0700, cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 43
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Oct 2004 16:35:22 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Oct 2004 16:35:24 -0700
X-Trace: forums-1-dub 1099006524 10.22.108.75 (28 Oct 2004 16:35:24 -0700)
X-Original-Trace: 28 Oct 2004 16:35:24 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3798
Article PK: 7690


jdyke wrote:
>
> So a question? do i have one? I'd like to know why dbsrv9.exe is
> consuming memory like it is, and if there is anything that i can do
> about it.
>

Based on the numbers you posted, I don't believe that 140 MB of RAM is
really that "large".

By default, ASA uses dynamic cache sizing. If a request comes into the
engine and there is not sufficient free memory in its cache, the cache
will grow. If after a period of time (of inactivity), ASA notices it
has lots of free space unused, the cache will shrink down.

You can control the initial, minimum and maximum cache sizes with the
parameters "-c", "-cl" and "-ch" respectively. By default, ASA will
have a maximum size of 256 MB, so as long as your machine has "enough"
RAM, ASA max'ing out shouldn't even be a problem.

You can find out what the peak cache usage is for your engine (during
the current session) by checking out the PeakCacheSize engine property.
If you find that it is 256MB, you might want to bump up the maximum
cache size (-ch switch) because your engine is indicating that it is
using up all the resources currently allocated to it.

Is there something in particular that concerns you about the 140MB usage?

Are the other machines you point out under similar loads to the one you
are concerned about?

If so, can you check the PeakCacheSize for those other servers to see if
they have, at some point, also had larger sizes than what you are
witnessing?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


jdyke Posted on 2004-10-29 00:27:15.0Z
Message-ID: <41818E5B.3070501@azimapower.com>
From: jdyke <jdyke@azimapower.com>
User-Agent: Mozilla Thunderbird 0.7 (Windows/20040616)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
To: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Subject: Re: growing memory consumption
References: <41815468$1@forums-2-dub> <41818237@forums-2-dub>
In-Reply-To: <41818237@forums-2-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 66.9.108.99
X-Original-Trace: 28 Oct 2004 17:27:11 -0700, 66.9.108.99
Lines: 29
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Oct 2004 17:27:13 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Oct 2004 17:27:15 -0700
X-Trace: forums-1-dub 1099009635 10.22.108.75 (28 Oct 2004 17:27:15 -0700)
X-Original-Trace: 28 Oct 2004 17:27:15 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3799
Article PK: 7691


Greg Fenton wrote:
> jdyke wrote:
>
>>
>> So a question? do i have one? I'd like to know why dbsrv9.exe is
>> consuming memory like it is, and if there is anything that i can do
>> about it.
>>
>
> Based on the numbers you posted, I don't believe that 140 MB of RAM is
> really that "large".

I agree, i guess it is the rate in which it acquired that amount of memory
caught me by suprise.

While this is not a great benchmark, we have a mysql server that takes the brunt
of our selects/updates/inserts that hovers around 5-20mg.

>
> Is there something in particular that concerns you about the 140MB usage?
Just that is stays allocated to the process, always increasing, but never
releases memory in low load times. For instance its now up above 150mg, but has
only had *minimal* activity in the past 4 hours.

Mostly i'm trying to understand 'normal'. I'm new to the database, and really
like it, as an aside....but we are getting ready to deploy it in a much more
intense environment and I want to better understand what it needs and how it acts.

Thanks for the comments.
Jeff


"Bruce Hay" <h_a_y Posted on 2004-10-29 13:09:27.0Z
From: "Bruce Hay" <h_a_y@i~a~n~y~w~h~e~r~e.c_o_m>
Newsgroups: ianywhere.public.general
References: <41815468$1@forums-2-dub> <41818237@forums-2-dub> <41818E5B.3070501@azimapower.com>
Subject: Re: growing memory consumption
Lines: 51
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: hay-t30.sybase.com
X-Original-NNTP-Posting-Host: hay-t30.sybase.com
Message-ID: <41824107$1@forums-1-dub>
Date: 29 Oct 2004 06:09:27 -0700
X-Trace: forums-1-dub 1099055367 10.25.99.98 (29 Oct 2004 06:09:27 -0700)
X-Original-Trace: 29 Oct 2004 06:09:27 -0700, hay-t30.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3801
Article PK: 7698

You may want to refer to the following section in the documentation. Note
that the cache will not shrink unless there is demand for memory from other
applications running on the machine.

ASA SQL User's Guide

Monitoring and Improving Performance

Using the cache to improve performance
Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

"jdyke" <jdyke@azimapower.com> wrote in message
news:41818E5B.3070501@azimapower.com...
> Greg Fenton wrote:
> > jdyke wrote:
> >
> >>
> >> So a question? do i have one? I'd like to know why dbsrv9.exe is
> >> consuming memory like it is, and if there is anything that i can do
> >> about it.
> >>
> >
> > Based on the numbers you posted, I don't believe that 140 MB of RAM is
> > really that "large".
> I agree, i guess it is the rate in which it acquired that amount of memory
> caught me by suprise.
>
> While this is not a great benchmark, we have a mysql server that takes the
brunt
> of our selects/updates/inserts that hovers around 5-20mg.
>
> >
> > Is there something in particular that concerns you about the 140MB
usage?
> Just that is stays allocated to the process, always increasing, but never
> releases memory in low load times. For instance its now up above 150mg,
but has
> only had *minimal* activity in the past 4 hours.
>
> Mostly i'm trying to understand 'normal'. I'm new to the database, and
really
> like it, as an aside....but we are getting ready to deploy it in a much
more
> intense environment and I want to better understand what it needs and how
it acts.
>
> Thanks for the comments.
> Jeff