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.

sp_configure "memory" unused space?

2 posts in Performance and Tuning Last posting was on 2011-09-27 15:50:59.0Z
rick_806 Posted on 2011-09-27 13:36:59.0Z
Sender: 9d7.4e81d069.1804289383@sybase.com
From: rick_806
Newsgroups: sybase.public.ase.performance+tuning
Subject: sp_configure "memory" unused space?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e81d17b.9fd.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 Sep 2011 06:36:59 -0700
X-Trace: forums-1-dub 1317130619 10.22.241.41 (27 Sep 2011 06:36:59 -0700)
X-Original-Trace: 27 Sep 2011 06:36:59 -0700, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:12971
Article PK: 91419

ASE 15.5 After running sp_configure "memory" I see that I
have 250MB of "available" memory (max mem - total logical).
Is this memory unused or is it used as necessary? If it is
never used then I should assign it to my default cache
right?

Thx,
rick_806


Bret Halford Posted on 2011-09-27 15:50:59.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.ase.performance+tuning
Subject: Re: sp_configure "memory" unused space?
References: <4e81d17b.9fd.1681692777@sybase.com>
In-Reply-To: <4e81d17b.9fd.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: <4e81f0e3$1@forums-1-dub>
Date: 27 Sep 2011 08:50:59 -0700
X-Trace: forums-1-dub 1317138659 10.22.241.152 (27 Sep 2011 08:50:59 -0700)
X-Original-Trace: 27 Sep 2011 08:50:59 -0700, vip152.sybase.com
Lines: 26
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:12972
Article PK: 91421


On 9/27/2011 7:36 AM, rick_806 wrote:
> ASE 15.5 After running sp_configure "memory" I see that I
> have 250MB of "available" memory (max mem - total logical).
> Is this memory unused or is it used as necessary? If it is
> never used then I should assign it to my default cache
> right?
>
> Thx,
> rick_806

If you have sp_configure "allocate max shared memory" [at startup]
turned on, then the memory has been grabbed by ASE but is not in
use. If that parameter is turned off, then ASE hasn't grabbed
it yet and it is just a limit. But if there is actual RAM available on
the system that isn't being used by other processes, then it would make
sense to grab it and assign it to a data cache.

Make sure the RAM is really available though, if you care about
performance you don't ASE getting swapped in and out. On platforms that
support it, you can use sp_configure "lock shared memory"
to prevent that.

-bret