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.

RAID and Sybase ASA

5 posts in General Discussion Last posting was on 2003-04-25 23:25:57.0Z
Doug Stone Posted on 2003-04-24 22:36:52.0Z
From: "Doug Stone" <nospamdstone@res-q.com>
Subject: RAID and Sybase ASA
Date: Thu, 24 Apr 2003 15:36:52 -0700
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <eCuV5IrCDHA.220@forums-1-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: adsl-64-168-188-84.dsl.lsan03.pacbell.net 64.168.188.84
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:943
Article PK: 3317

Hi. What RAID (1,5,7,10) is recommended for use with ASA 8?
In a recent iAnywhere presentation, I think RAID 1 or 10 was mentioned as
the preference.
What is there about ASA and RAID that one RAID spec would be preferred over
another?

Thanks,
Doug


Robert Waywell Posted on 2003-04-25 12:26:20.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <eCuV5IrCDHA.220@forums-1-dub>
Subject: Re: RAID and Sybase ASA
Date: Fri, 25 Apr 2003 08:26:20 -0400
Lines: 97
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <O8jFlayCDHA.194@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rwaywell-pc.sybase.com 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:949
Article PK: 2951

I replied to your earlier post with this same question. In case you were
unable to retrieve that reply, I have copied it here:

That was me.

The drivers for a preference are both data redundancy and performance.
With RAID 0 you get striping which spreads a single file across multiple
disks, but does not duplicate the same piece of data anywhere. This is great
for performance but does nothing for data redundancy. With RAID 1 you get
data mirroring which means each piece of data is written in 2 places. This
is great for data redundancy, it may help performance on read operations but
it slows down write operations. RAID 5 provides data striping at the byte
level and uses a parity disk to provide redundancy. Again this can improve
read performance but increases write costs. So the preferred configuration
is RAID 10 (or 0+1 ) which provides striping and mirroring. In this case the
striping helps to offset the cost of the mirroring. The cost of a RAID 10
system is that you need 2X as many disks as the final volume to accomodate
the mirroring.

By the way, this recommended configuration is not specific to ASA or
even to databases. The tradeoffs between redundancy and performance apply
equal to all file access.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Doug Stone" <nospamdstone@res-q.com> wrote in message
news:uxiMDQSBDHA.220@forums-1-dub...
>
> One of our customers planning to purchase a server for ASA 8.
> In a recent Sybase ASA seminar, the presenter mentioned a preference for
one
> RAID technology over others.
> What is the preferred RAID for ASA and what drives the preference?
>
> Thanks,
> Doug
>
>

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Doug Stone" <nospamdstone@res-q.com> wrote in message
news:eCuV5IrCDHA.220@forums-1-dub...
>
> Hi. What RAID (1,5,7,10) is recommended for use with ASA 8?
> In a recent iAnywhere presentation, I think RAID 1 or 10 was mentioned as
> the preference.
> What is there about ASA and RAID that one RAID spec would be preferred
over
> another?
>
> Thanks,
> Doug
>
>


Doug Stone Posted on 2003-04-25 23:25:57.0Z
From: "Doug Stone" <nospamdstone@res-q.com>
References: <eCuV5IrCDHA.220@forums-1-dub> <O8jFlayCDHA.194@forums-2-dub>
Subject: Re: RAID and Sybase ASA
Date: Fri, 25 Apr 2003 16:25:57 -0700
Lines: 110
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <#1utiK4CDHA.283@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: adsl-64-164-174-189.dsl.lsan03.pacbell.net 64.164.174.189
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:956
Article PK: 2957

Robert, thanks for the repost. Yes, I missed your original post on this
topic.

"Robert Waywell" <rwaywell@ianywhere.com> wrote in message
news:O8jFlayCDHA.194@forums-2-dub...
> I replied to your earlier post with this same question. In case you were
> unable to retrieve that reply, I have copied it here:
>
> That was me.
>
> The drivers for a preference are both data redundancy and performance.
> With RAID 0 you get striping which spreads a single file across multiple
> disks, but does not duplicate the same piece of data anywhere. This is
great
> for performance but does nothing for data redundancy. With RAID 1 you get
> data mirroring which means each piece of data is written in 2 places. This
> is great for data redundancy, it may help performance on read operations
but
> it slows down write operations. RAID 5 provides data striping at the byte
> level and uses a parity disk to provide redundancy. Again this can improve
> read performance but increases write costs. So the preferred configuration
> is RAID 10 (or 0+1 ) which provides striping and mirroring. In this case
the
> striping helps to offset the cost of the mirroring. The cost of a RAID 10
> system is that you need 2X as many disks as the final volume to accomodate
> the mirroring.
>
> By the way, this recommended configuration is not specific to ASA or
> even to databases. The tradeoffs between redundancy and performance apply
> equal to all file access.
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> "Doug Stone" <nospamdstone@res-q.com> wrote in message
> news:uxiMDQSBDHA.220@forums-1-dub...
> >
> > One of our customers planning to purchase a server for ASA 8.
> > In a recent Sybase ASA seminar, the presenter mentioned a preference for
> one
> > RAID technology over others.
> > What is the preferred RAID for ASA and what drives the preference?
> >
> > Thanks,
> > Doug
> >
> >
>
>
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> "Doug Stone" <nospamdstone@res-q.com> wrote in message
> news:eCuV5IrCDHA.220@forums-1-dub...
> >
> > Hi. What RAID (1,5,7,10) is recommended for use with ASA 8?
> > In a recent iAnywhere presentation, I think RAID 1 or 10 was mentioned
as
> > the preference.
> > What is there about ASA and RAID that one RAID spec would be preferred
> over
> > another?
> >
> > Thanks,
> > Doug
> >
> >
>
>


Breck Carter [TeamSybase] Posted on 2003-04-25 13:07:25.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Subject: Re: RAID and Sybase ASA
Date: Fri, 25 Apr 2003 09:07:25 -0400
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <3nciav4t8m0q11mvdovu91ps48vrv9vtac@4ax.com>
References: <eCuV5IrCDHA.220@forums-1-dub>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: nn003.canpar.ca 204.225.91.43
Lines: 14
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:951
Article PK: 2953

I think RAID 0+1 is a recommended for databases in general, not just
ASA.

Breck

On Thu, 24 Apr 2003 15:36:52 -0700, "Doug Stone"

<nospamdstone@res-q.com> wrote:

>
>Hi. What RAID (1,5,7,10) is recommended for use with ASA 8?
>In a recent iAnywhere presentation, I think RAID 1 or 10 was mentioned as
>the preference.
>What is there about ASA and RAID that one RAID spec would be preferred over
>another?
>
>Thanks,
>Doug
>

bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
http://www.risingroad.com


Michael Gould Posted on 2003-04-25 00:22:59.0Z
From: "Michael Gould" <mgould@omnicc.com>
References: <eCuV5IrCDHA.220@forums-1-dub>
Subject: Re: RAID and Sybase ASA
Date: Thu, 24 Apr 2003 20:22:59 -0400
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <#kLN9EsCDHA.220@forums-1-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: adsl-17-253-234.jax.bellsouth.net 68.17.253.234
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:945
Article PK: 3321

Doug,

We use raid 5 but are switching to 0+1. We really don't have any speed
problems because our raid controller is backed up with 128 Megs of RAM but
everyone says that 0+1 is optimal.

Michael Gould

"Doug Stone" <nospamdstone@res-q.com> wrote in message
news:eCuV5IrCDHA.220@forums-1-dub...
>
> Hi. What RAID (1,5,7,10) is recommended for use with ASA 8?
> In a recent iAnywhere presentation, I think RAID 1 or 10 was mentioned as
> the preference.
> What is there about ASA and RAID that one RAID spec would be preferred
over
> another?
>
> Thanks,
> Doug
>
>