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.

Sybase on SVC Storage

5 posts in Cluster Last posting was on 2008-07-09 14:30:58.0Z
Joe Gard Posted on 2008-07-04 01:18:43.0Z
Sender: 7b0f.486d79b6.846930886@sybase.com
From: joe gard
Newsgroups: sybase.public.ase.cluster
Subject: Sybase on SVC Storage
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <486d7a73.7b27.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 3 Jul 2008 18:18:43 -0700
X-Trace: forums-1-dub 1215134323 10.22.241.41 (3 Jul 2008 18:18:43 -0700)
X-Original-Trace: 3 Jul 2008 18:18:43 -0700, 10.22.241.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:81
Article PK: 48365

I need some verification and understanding of Sybase
databases residing on SVC type storage. Specifically,
whether the SVC vDisk must be sequential in nature for best
performance, of if there is no impact if the vDisk is
striped.

Any opinions would be appreciated


peter collard Posted on 2008-07-07 12:22:03.0Z
Message-ID: <48720a6a@forums-1-dub>
From: peter collard <peterrrrrr@glossop.org>
Subject: Re: Sybase on SVC Storage
Newsgroups: sybase.public.ase.cluster
References: <486d7a73.7b27.1681692777@sybase.com>
Lines: 12
User-Agent: KNode/0.10.4
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 7 Jul 2008 05:22:03 -0700
X-Trace: forums-1-dub 1215433323 10.22.241.152 (7 Jul 2008 05:22:03 -0700)
X-Original-Trace: 7 Jul 2008 05:22:03 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:82
Article PK: 48364


joe gard wrote:

> I need some verification and understanding of Sybase
> databases residing on SVC type storage. Specifically,
> whether the SVC vDisk must be sequential in nature for best
> performance, of if there is no impact if the vDisk is
> striped.

If you think of SAN Volume Controllers as just controllers of multiple disks
and disk packs then theres no difference from any other arrangement - the
name of the game is to spread the load evenly across the spindles (and make
sure no other apps are hitting your spindles!)


Joe Gard Posted on 2008-07-07 15:06:53.0Z
Sender: 2f14.4872298d.1804289383@sybase.com
From: joe gard
Newsgroups: sybase.public.ase.cluster
Subject: Re: Sybase on SVC Storage
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4872310d.30c2.1681692777@sybase.com>
References: <48720a6a@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Jul 2008 08:06:53 -0700
X-Trace: forums-1-dub 1215443213 10.22.241.41 (7 Jul 2008 08:06:53 -0700)
X-Original-Trace: 7 Jul 2008 08:06:53 -0700, 10.22.241.41
Lines: 23
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:84
Article PK: 48366


> joe gard wrote:
>
> > I need some verification and understanding of Sybase
> > databases residing on SVC type storage. Specifically,
> > whether the SVC vDisk must be sequential in nature for
> > best performance, of if there is no impact if the vDisk
> > is striped.
>
> If you think of SAN Volume Controllers as just controllers
> of multiple disks and disk packs then theres no difference
> from any other arrangement - the name of the game is to
> spread the load evenly across the spindles (and make sure
> no other apps are hitting your spindles!)

Thank you for your quick response. This leads us to another
question ...

Does Sybase Support have any data regarding their databases
on SVC vDisks as best configured sequential and not striped.

A comment IBM indicated to us is you don't want to 'stripe'
something an application has already striped across storage.
Do you know if Sybase stripes data when it's handed
disk????


David Wein Posted on 2008-07-08 21:06:09.0Z
From: David Wein <david.wein@sybase.com>
User-Agent: Thunderbird 1.5.0.12 (X11/20071020)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.cluster
Subject: Re: Sybase on SVC Storage
References: <48720a6a@forums-1-dub> <4872310d.30c2.1681692777@sybase.com>
In-Reply-To: <4872310d.30c2.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: <4873d6c1$1@forums-1-dub>
Date: 8 Jul 2008 14:06:09 -0700
X-Trace: forums-1-dub 1215551169 10.22.241.152 (8 Jul 2008 14:06:09 -0700)
X-Original-Trace: 8 Jul 2008 14:06:09 -0700, vip152.sybase.com
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:86
Article PK: 48369


> A comment IBM indicated to us is you don't want to 'stripe'
> something an application has already striped across storage.
> Do you know if Sybase stripes data when it's handed
> disk????

This post appears off topic for the newsgroup, but in terms of storage
allocation, ASE doesn't do striping.

-Dave


svc Posted on 2008-07-09 14:30:58.0Z
Sender: 2f14.4872298d.1804289383@sybase.com
From: svc
Newsgroups: sybase.public.ase.cluster
Subject: Re: Sybase on SVC Storage
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4874cba2.10e2.1681692777@sybase.com>
References: <4873d6c1$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Jul 2008 07:30:58 -0700
X-Trace: forums-1-dub 1215613858 10.22.241.41 (9 Jul 2008 07:30:58 -0700)
X-Original-Trace: 9 Jul 2008 07:30:58 -0700, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:87
Article PK: 48370

Thanks .. I will get this in the proper newsgroup

> > A comment IBM indicated to us is you don't want to
> > 'stripe' something an application has already striped
> > across storage. Do you know if Sybase stripes data when
> > it's handed disk????
>
> This post appears off topic for the newsgroup, but in
> terms of storage allocation, ASE doesn't do striping.
>
> -Dave
>