[AccessD] SSDs and BE storage

All,

SSDs sound ideal for server applications, except for one nagging question:
when will it wear out?

SSD endurance summary
http://www.storagesearch.com/ssdmyths-endurance.html


But, there are circumstances where SSDs make a compelling argument for
adoption:

SSDs replacing HDDs? that's not exactly the way it happened
http://www.storagesearch.com/bitmicro-art3.html


If you do spring for them, get the (much more expensive) server-rated SSDs
using SLC memory -- see response to Micker in comments:

Debunking SSD lifespan and random write performance concerns
http://maxschireson.com/2011/04/21/debunking-ssd-lifespan-and-random-write-performance-concerns/

Don't expect consumer-level SSDs to last very long in a server environment.

-Ken



>
> ---------- Forwarded message ----------
> From: jwcolby <jwcolby at colbyconsulting.com>
> To: Access Developers discussion and problem solving <
> accessd at databaseadvisors.com>
> Date: Tue, 20 Sep 2011 08:10:26 -0400
> Subject: Re: [AccessD] SSDs and BE storage
> Well, it seems I will be answering this question in the next few weeks.
>  The client is building a server in the next couple of weeks, which will
> include a raid1 SSD as the data store.  Phase 1 of the story will be to move
> the access BEs to that SSD and use that while we migrate the data into
> something else (MySQL maybe).
>
> My FE / framework logs the start / stop time  when opening forms so it
> should be easy to discover whether the SSD makes things significantly
> faster.
>
> John W. Colby
> www.ColbyConsulting.com
>
> ---------- Forwarded message ----------
> From: "Dan Waters" <df.waters at comcast.net>
> To: "'Access Developers discussion and problem solving'" <
> accessd at databaseadvisors.com>
> Date: Tue, 20 Sep 2011 07:48:52 -0500
> Subject: Re: [AccessD] SSDs and BE storage
> Hi John,
>
> A few months ago I switched to using an SSD for the Windows 7 OS and
> applications, and a WD Black HD for data storage.  And yes, things are
> significantly faster.  If I had a 2nd gen Intel CPU I'd see another jump in
> speed.  But the way it is now, every Access file I open is up in about 1
> second (if it doesn't have startup code).  VS 2010 takes about 35 seconds
> to
> open and a VS app takes about 5 seconds to open.
>
> If you're going to all SSD, then you'll see a dramatic difference.
>
> Dan
>
>