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.

lock and cache

2 posts in Cluster Last posting was on 2008-04-02 22:23:18.0Z
fakeid Posted on 2008-04-01 21:09:29.0Z
Sender: 3ffb.47f25aaa.1804289383@sybase.com
From: fakeid
Newsgroups: sybase.public.ase.cluster
Subject: lock and cache
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47f2a489.46bc.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 1 Apr 2008 13:09:29 -0800
X-Trace: forums-1-dub 1207084169 10.22.241.41 (1 Apr 2008 13:09:29 -0800)
X-Original-Trace: 1 Apr 2008 13:09:29 -0800, 10.22.241.41
Lines: 18
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:38
Article PK: 48323

i was going through the SDC user guide just released.

the lock and the cache interface is still not clear!

first thing comes to mind is, there will be more lock
contention?

we dont have much of the resource contention, we have an
oltp high i/o intensive apps, the load balancing probably
will not be a big plus; availability is what we probably
would achieve, but then we already have ASE HA in companion
mode.

any additional information regarding the "lock management",
"Buffer cache/Object coherency"?

is cluster interprocess communication comparable to
RAC-cache fusion in respect to speed?


Rob Verschoor Posted on 2008-04-02 22:23:18.0Z
Reply-To: "Rob Verschoor" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
From: "Rob Verschoor" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.cluster
References: <47f2a489.46bc.1681692777@sybase.com>
Subject: Re: lock and cache
Lines: 46
Organization: Sypron B.V. / TeamSybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47f40756@forums-1-dub>
Date: 2 Apr 2008 14:23:18 -0800
X-Trace: forums-1-dub 1207174998 10.22.241.152 (2 Apr 2008 14:23:18 -0800)
X-Original-Trace: 2 Apr 2008 14:23:18 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:41
Article PK: 48327


<fakeid> wrote in message news:47f2a489.46bc.1681692777@sybase.com...
>i was going through the SDC user guide just released.
>
> the lock and the cache interface is still not clear!
>
> first thing comes to mind is, there will be more lock
> contention?
>
> we dont have much of the resource contention, we have an
> oltp high i/o intensive apps, the load balancing probably
> will not be a big plus; availability is what we probably
> would achieve, but then we already have ASE HA in companion
> mode.
>
> any additional information regarding the "lock management",
> "Buffer cache/Object coherency"?
>
> is cluster interprocess communication comparable to
> RAC-cache fusion in respect to speed?

There is no additional lock contention caused by the cluster architecture
itself. However, the distributed locking is more resource-intensive, just as
is the case for RAC, and the same principles apply: applications should aim
to minimise the need for interprocess communication for best performance.

HTH,

Rob V.
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------