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.

How to increase memoey size for SQL Anywhere studio 8 database

2 posts in QAnywhere Last posting was on 2008-10-15 22:22:32.0Z
Robert Chen Posted on 2008-10-15 21:39:56.0Z
Sender: 25c0.48f6615c.1804289383@sybase.com
From: Robert Chen
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: How to increase memoey size for SQL Anywhere studio 8 database
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48f6632c.25eb.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 15 Oct 2008 14:39:56 -0700
X-Trace: forums-1-dub 1224106796 10.22.241.41 (15 Oct 2008 14:39:56 -0700)
X-Original-Trace: 15 Oct 2008 14:39:56 -0700, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:283
Article PK: 10504

Hi all,
I've just got a new Window 2003 server with 10 GB memory,
would like to increase allocate memoey size for SQL Anywhere
studio 8 database server, How do I do it?
TIA


Jeff Albion (Sybase iAnywhere) Posted on 2008-10-15 22:22:32.0Z
From: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.17 (Windows/20080914)
MIME-Version: 1.0
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: Re: How to increase memoey size for SQL Anywhere studio 8 database
References: <48f6632c.25eb.1681692777@sybase.com>
In-Reply-To: <48f6632c.25eb.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: <48f66d28$1@forums-1-dub>
Date: 15 Oct 2008 15:22:32 -0700
X-Trace: forums-1-dub 1224109352 10.22.241.152 (15 Oct 2008 15:22:32 -0700)
X-Original-Trace: 15 Oct 2008 15:22:32 -0700, vip152.sybase.com
Lines: 31
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:285
Article PK: 10500

Robert,

You can use the "-cw" switch to enable AWE memory extensions. (See:
http://manuals.sybase.com/onlinebooks/group-sas/awg0802e/dbdaen8/@Generic__BookTextView/12111;pt=12111#X
).

Note that the database can only use the AWE memory pages to store
read-only data pages (any dirty or manipulated pages will still reside
in the lower 2GB of user memory space).

You can then use the initial cache size switch (-c) to use additional
memory.

Regards,

Robert Chen wrote:
> Hi all,
> I've just got a new Window 2003 server with 10 GB memory,
> would like to increase allocate memoey size for SQL Anywhere
> studio 8 database server, How do I do it?
> TIA

--
Jeff Albion, SQL Anywhere Engineering
Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0