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.

low memory on RSSD

2 posts in General Discussion Last posting was on 2011-07-21 18:12:23.0Z
David Posted on 2011-07-21 09:20:46.0Z
Sender: 329d.4e254b4f.1804289383@sybase.com
From: David
Newsgroups: sybase.public.rep-server
Subject: low memory on RSSD
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e27ef6e.4f6b.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 21 Jul 2011 02:20:46 -0700
X-Trace: forums-1-dub 1311240046 10.22.241.41 (21 Jul 2011 02:20:46 -0700)
X-Original-Trace: 21 Jul 2011 02:20:46 -0700, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9004
Article PK: 841874

Our production RSSD ASE server has only been assigned 38Mb
of memory, will this cause any performance issues ,it
contains two RSSD databases? what is the rule of thumb for
memory allocatin for an RSSD ASE server?


"Mark A. Parsons" <iron_horse Posted on 2011-07-21 18:12:23.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Re: low memory on RSSD
References: <4e27ef6e.4f6b.1681692777@sybase.com>
In-Reply-To: <4e27ef6e.4f6b.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: <4e286c07$1@forums-1-dub>
Date: 21 Jul 2011 11:12:23 -0700
X-Trace: forums-1-dub 1311271943 10.22.241.152 (21 Jul 2011 11:12:23 -0700)
X-Original-Trace: 21 Jul 2011 11:12:23 -0700, vip152.sybase.com
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9005
Article PK: 870169

It's really going to depend on the number of databases, routes, repdefs/subscriptions, size of stable device (ie, number
of segments) ... all of these are going to drive the number of pages floating around in cache.

You'll also need to take into consideration the version of ASE and the features you have enabled. For example, ASE 15.x
is going to require more proc cache, and enabling statement_cache (another memory hog) is usually a good idea with ASE
15.x but will obviously require more memory.

You'll also need to take into consideration the number of active connections into the ASE and their behavior. For
example, most 3rd party monitoring tools are going to have connections into the ASE, RSSD-specific queries and/or procs
that they need to run, and most likely they'll have MDA tables enabled (another resource hog) ... all of which will
require more ASE resources.

I'd suggest using the same methods you would normally use for tuning a dataserver, eg, sp_sysmon, MDA tables, etc.

On 07/21/2011 05:20, David wrote:
> Our production RSSD ASE server has only been assigned 38Mb
> of memory, will this cause any performance issues ,it
> contains two RSSD databases? what is the rule of thumb for
> memory allocatin for an RSSD ASE server?