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.

Max_Cache_Memory Question

3 posts in Clipper Last posting was on 2007-11-15 20:13:06.0Z
Jan Sperling Posted on 2007-11-15 18:04:48.0Z
Reply-To: "Jan Sperling" <sperling@racsa.co.cr>
From: "Jan Sperling" <sperling@racsa.co.cr>
Newsgroups: advantage.clipper
Subject: Max_Cache_Memory Question
Date: Thu, 15 Nov 2007 10:04:48 -0800
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 190.10.0.78
Message-ID: <473c6ce6@solutions.advantagedatabase.com>
X-Trace: 15 Nov 2007 08:59:34 -0700, 190.10.0.78
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!190.10.0.78
Xref: solutions.advantagedatabase.com Advantage.Clipper:4276
Article PK: 1106956

Hi:

I was reading about the MAX_CACHE_MEMORY (8.1), so I configured my server
with a 300 value.

However, I cannot see really if ADS is grabbing this amount of memory...
Where can I check that ADS is really reserving 300Mb of memory. I look at
at the ADS process, and it has only 31Mb of memory in usage.

Tx in advance,

Jan Sperling


Alex Wong (ADS) Posted on 2007-11-15 17:27:53.0Z
From: "Alex Wong \(ADS\)" <nobody@sybase.com>
Newsgroups: advantage.clipper
References: <473c6ce6@solutions.advantagedatabase.com>
Subject: Re: Max_Cache_Memory Question
Date: Thu, 15 Nov 2007 10:27:53 -0700
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.219
Message-ID: <473c805d@solutions.advantagedatabase.com>
X-Trace: 15 Nov 2007 10:22:37 -0700, 10.24.38.219
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.219
Xref: solutions.advantagedatabase.com Advantage.Clipper:4277
Article PK: 1106955

Hi Jan,

ADS only reserves memory when needed. The configuration just tells ADS to
maximum memory to reserve for caching index and temporary table.

--
Alex

"Jan Sperling" <sperling@racsa.co.cr> wrote in message
news:473c6ce6@solutions.advantagedatabase.com...
> Hi:
>
> I was reading about the MAX_CACHE_MEMORY (8.1), so I configured my server
> with a 300 value.
>
> However, I cannot see really if ADS is grabbing this amount of memory...
> Where can I check that ADS is really reserving 300Mb of memory. I look at
> at the ADS process, and it has only 31Mb of memory in usage.
>
> Tx in advance,
>
> Jan Sperling
>


Jan Sperling Posted on 2007-11-15 20:13:06.0Z
Reply-To: "Jan Sperling" <sperling@racsa.co.cr>
From: "Jan Sperling" <sperling@racsa.co.cr>
Newsgroups: advantage.clipper
References: <473c6ce6@solutions.advantagedatabase.com> <473c805d@solutions.advantagedatabase.com>
Subject: Re: Max_Cache_Memory Question
Date: Thu, 15 Nov 2007 12:13:06 -0800
Lines: 6
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 190.10.0.78
Message-ID: <473c8af9@solutions.advantagedatabase.com>
X-Trace: 15 Nov 2007 11:07:53 -0700, 190.10.0.78
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!190.10.0.78
Xref: solutions.advantagedatabase.com Advantage.Clipper:4279
Article PK: 1106960

Tx Alex (both questions)

R, Jan