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 and Sun Flash Drive Arrays

3 posts in General Discussion Last posting was on 2009-06-29 12:54:07.0Z
Schmand Posted on 2009-06-26 17:47:56.0Z
From: Schmand <waynehapp@earthlink.net>
Newsgroups: sybase.public.ase.general
Subject: Sybase and Sun Flash Drive Arrays
Date: Fri, 26 Jun 2009 10:47:56 -0700 (PDT)
Organization: http://groups.google.com
Lines: 16
Message-ID: <fbae0480-6f3e-448c-adf8-0ff48c952bfb@j20g2000vbp.googlegroups.com>
NNTP-Posting-Host: 76.98.183.64
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1246038476 31182 127.0.0.1 (26 Jun 2009 17:47:56 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 26 Jun 2009 17:47:56 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: j20g2000vbp.googlegroups.com; posting-host=76.98.183.64; posting-account=gQ11RwkAAAB-HzUZ3V4kSgEUhFzoISOv
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_7; en-us) AppleWebKit/530.18 (KHTML, like Gecko) Version/4.0.1 Safari/530.18,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!nlpi057.nbdc.sbc.com!prodigy.net!news.glorb.com!postnews.google.com!j20g2000vbp.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27924
Article PK: 77171

The good folks I work for have installed a "flash drive array" that
sun sold them. Does anyone have any experience with these things? I'm
wondering if they're really that more fast then disk.

The first thing my DBA did was load databases onto them. While leaving
the transaction log devices on regular disk. Seems to me that in this
scenario, the flash can't be faster then the drive where the logs are,
Oh and the flash drives suffered corruption before the first day was
over.

My first thought was to put tempdb's on them. But I really have no
idea why these devices exist.

Any experience with these things? Or maybe someone can point me to a
blog or something where they're talked about.


Glenn Paulley [Sybase iAnywhere] Posted on 2009-06-26 20:25:49.0Z
From: "Glenn Paulley [Sybase iAnywhere]" <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Sybase and Sun Flash Drive Arrays
References: <fbae0480-6f3e-448c-adf8-0ff48c952bfb@j20g2000vbp.googlegroups.com>
In-Reply-To: <fbae0480-6f3e-448c-adf8-0ff48c952bfb@j20g2000vbp.googlegroups.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: <4a452ecd$5@forums-3-dub.sybase.com>
Date: 26 Jun 2009 13:25:49 -0700
X-Trace: forums-3-dub.sybase.com 1246047949 10.22.241.152 (26 Jun 2009 13:25:49 -0700)
X-Original-Trace: 26 Jun 2009 13:25:49 -0700, vip152.sybase.com
Lines: 48
X-Authenticated-User: techsupp
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27925
Article PK: 77172

Feel free to browse my blog at

http://iablog.sybase.com/paulley

where I've posted a number of articles about flash devices. James
Hamilton of Amazon has analyzed various scenarios covering the use of
flash SSDs on both client and server machines; it is very interesting
reading. For James' blog, go to

http://perspectives.mvdirona.com/

Glenn

Schmand wrote:
> The good folks I work for have installed a "flash drive array" that
> sun sold them. Does anyone have any experience with these things? I'm
> wondering if they're really that more fast then disk.
>
> The first thing my DBA did was load databases onto them. While leaving
> the transaction log devices on regular disk. Seems to me that in this
> scenario, the flash can't be faster then the drive where the logs are,
> Oh and the flash drives suffered corruption before the first day was
> over.
>
> My first thought was to put tempdb's on them. But I really have no
> idea why these devices exist.
>
> Any experience with these things? Or maybe someone can point me to a
> blog or something where they're talked about.

--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

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

To Submit Bug Reports: http://case-express.sybase.com

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
Sybase iAnywhere pages at
http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport


Jeff Garbus Posted on 2009-06-29 12:54:07.0Z
From: Jeff Garbus <jeff@soaringeagle.biz>
Newsgroups: sybase.public.ase.general
Subject: Re: Sybase and Sun Flash Drive Arrays
Date: Mon, 29 Jun 2009 05:54:07 -0700 (PDT)
Organization: http://groups.google.com
Lines: 20
Message-ID: <3260f5c5-65c4-4ffa-bea5-e50dbe0b3b93@n21g2000vba.googlegroups.com>
References: <fbae0480-6f3e-448c-adf8-0ff48c952bfb@j20g2000vbp.googlegroups.com>
NNTP-Posting-Host: 24.26.82.126
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1246280047 25152 127.0.0.1 (29 Jun 2009 12:54:07 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 29 Jun 2009 12:54:07 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: n21g2000vba.googlegroups.com; posting-host=24.26.82.126; posting-account=_JvdkgoAAABJg-zfXaOxIqNr4fweMvdh
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; GTB6; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; InfoPath.2; .NET CLR 3.5.30729; .NET CLR 3.0.30618; OfficeLiveConnector.1.3; OfficeLivePatch.0.0),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!n21g2000vba.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27928
Article PK: 77180


On Jun 26, 1:47 pm, Schmand <wayneh...@earthlink.net> wrote:
> The good folks I work for have installed a "flash drive array" that
> sun sold them.  Does anyone have any experience with these things? I'm
> wondering if they're really that more fast then disk.
>
> The first thing my DBA did was load databases onto them. While leaving
> the transaction log devices on regular disk.  Seems to me that in this
> scenario, the flash can't be faster then the drive where the logs are,
> Oh and the flash drives suffered corruption before the first day was
> over.
>
> My first thought was to put tempdb's on them. But I really have no
> idea why these devices exist.
>
> Any experience with these things? Or maybe someone can point me to a
> blog or something where they're talked about.

You are absolutely right; in a DSS environment, it makes sense to put
disk on the faster subsystem, in an OLTP environement, you want to
prioritize Log/Tempdb, depending on how your application uses them.