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.

Restricting memory growth

4 posts in General Discussion Last posting was on 2010-06-25 19:59:21.0Z
Brown Posted on 2010-06-25 00:26:53.0Z
Sender: 3180.4c23f3d2.1804289383@sybase.com
From: Brown
Newsgroups: ianywhere.public.general
Subject: Restricting memory growth
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c23f7cd.31fa.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 Jun 2010 17:26:53 -0700
X-Trace: forums-1-dub 1277425613 10.22.241.41 (24 Jun 2010 17:26:53 -0700)
X-Original-Trace: 24 Jun 2010 17:26:53 -0700, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8060
Article PK: 7084

I have SQL Anywhere (dbsrv11) on client site. It is
installed on XP Embedded. The users complain that
dbsrv11.exe takes up most of the memory on the computer. I
do not allow transaction log to grow to avoid further memory
use. We maintain 30 bytes per record and every minute 600 of
those 30 bytes are feed into the table table. We maintain
six months of data on this database.
I am planing to add switches to avoid memory growth. Are
there any other special tuning actions that I should take.
Is dbsrv11.exe is too much for Embedded.


Glenn Paulley [Sybase iAnywhere] Posted on 2010-06-25 11:57:28.0Z
From: "Glenn Paulley [Sybase iAnywhere]" <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.24 (Windows/20100228)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Restricting memory growth
References: <4c23f7cd.31fa.1681692777@sybase.com>
In-Reply-To: <4c23f7cd.31fa.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c2499a8$1@forums-1-dub>
Date: 25 Jun 2010 04:57:28 -0700
X-Trace: forums-1-dub 1277467048 10.22.241.152 (25 Jun 2010 04:57:28 -0700)
X-Original-Trace: 25 Jun 2010 04:57:28 -0700, vip152.sybase.com
Lines: 48
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8061
Article PK: 7083

SQL Anywhere automatically resizes its buffer pool (both growing AND
shrinking) in response to the database workload and to requirements of
other applications on the machine. If your clients are using Task
Manager to determine memory size, it is likely they are not seeing the
correct values for memory consumption because Task Manager doesn't
report actual malloc'd memory sizes; see

http://iablog.sybase.com/paulley/2008/10/pitfalls-of-using-windows-task-manager/

However, if desired you can limit the maximum amount of buffer pool used
by the server by specifying the -ch command line switch at server start.
You should monitor memory consumption using Sybase Central or Windows
Performance Monitor for your client's workload, and test your
application's performance to ensure that restricting the maximum buffer
pool size doesn't impact performance too negatively.

Glenn

Brown wrote:
> I have SQL Anywhere (dbsrv11) on client site. It is
> installed on XP Embedded. The users complain that
> dbsrv11.exe takes up most of the memory on the computer. I
> do not allow transaction log to grow to avoid further memory
> use. We maintain 30 bytes per record and every minute 600 of
> those 30 bytes are feed into the table table. We maintain
> six months of data on this database.
> I am planing to add switches to avoid memory growth. Are
> there any other special tuning actions that I should take.
> Is dbsrv11.exe is too much for Embedded.

--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport


John Smirnios [Sybase] Posted on 2010-06-25 15:10:19.0Z
From: "John Smirnios [Sybase]" <smirnios_at_sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.10) Gecko/20100512 Thunderbird/3.0.5
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Restricting memory growth
References: <4c23f7cd.31fa.1681692777@sybase.com>
In-Reply-To: <4c23f7cd.31fa.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c24c6db$1@forums-1-dub>
Date: 25 Jun 2010 08:10:19 -0700
X-Trace: forums-1-dub 1277478619 10.22.241.152 (25 Jun 2010 08:10:19 -0700)
X-Original-Trace: 25 Jun 2010 08:10:19 -0700, vip152.sybase.com
Lines: 28
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8062
Article PK: 7086

The statements seems a bit contradictory. Are we talking about memory
use or disk storage? Is dbsrv11 taking up too much RAM or are these rows
taking up too much space on a storage medium?

Cache size/RAM use can be controlled easily as Glenn pointed out.
Database files do not shrink but free space is generally reused.

-john.

--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

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

On 6/24/2010 8:26 PM, Brown wrote:
> I have SQL Anywhere (dbsrv11) on client site. It is
> installed on XP Embedded. The users complain that
> dbsrv11.exe takes up most of the memory on the computer. I
> do not allow transaction log to grow to avoid further memory
> use. We maintain 30 bytes per record and every minute 600 of
> those 30 bytes are feed into the table table. We maintain
> six months of data on this database.
> I am planing to add switches to avoid memory growth. Are
> there any other special tuning actions that I should take.
> Is dbsrv11.exe is too much for Embedded.


Brown Posted on 2010-06-25 19:59:21.0Z
Sender: 5699.4c2509c2.846930886@sybase.com
From: Brown
Newsgroups: ianywhere.public.general
Subject: Re: Restricting memory growth
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c250a99.56c5.1681692777@sybase.com>
References: <4c24c6db$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 25 Jun 2010 12:59:21 -0700
X-Trace: forums-1-dub 1277495961 10.22.241.41 (25 Jun 2010 12:59:21 -0700)
X-Original-Trace: 25 Jun 2010 12:59:21 -0700, 10.22.241.41
Lines: 35
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8063
Article PK: 7087

Thank you all

I was referring to memory use.

> The statements seems a bit contradictory. Are we talking
> about memory use or disk storage? Is dbsrv11 taking up
> too much RAM or are these rows taking up too much space
> on a storage medium?
>
> Cache size/RAM use can be controlled easily as Glenn
> pointed out. Database files do not shrink but free space
> is generally reused.
>
> -john.
>
> --
> John Smirnios
> Senior Software Developer
> iAnywhere Solutions Engineering
>
> Whitepapers, TechDocs, bug fixes are all available through
> the iAnywhere Developer Community at
> http://www.ianywhere.com/developer
>
> On 6/24/2010 8:26 PM, Brown wrote:
> > I have SQL Anywhere (dbsrv11) on client site. It is
> > installed on XP Embedded. The users complain that
> > dbsrv11.exe takes up most of the memory on the computer.
> > I do not allow transaction log to grow to avoid further
> > memory use. We maintain 30 bytes per record and every
> > minute 600 of those 30 bytes are feed into the table
> > table. We maintain six months of data on this database.
> > I am planing to add switches to avoid memory growth. Are
> > there any other special tuning actions that I should
> > take. Is dbsrv11.exe is too much for Embedded.