[AccessD] SSDs and BE storage

The system they are building includes a latest generation 8 port Areca Raid controller, with 3x 
120gb SSDs and 5X WD Black 1 gb drives.  We will be going Raid 5 with hot spare for the SSDs as well 
as the rotating so it should be reasonably fast with a hardware controller to buffer things.

The SSD will be reserved for only the data store container files, which at first will be the Access 
MDB files.  As we migrate to MySQL or SQL Server those data files will go on the SSD.

John W. Colby
www.ColbyConsulting.com

On 9/20/2011 8:48 AM, Dan Waters wrote:
> 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
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Tuesday, September 20, 2011 7:10 AM
> To: Access Developers discussion and problem solving
> 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
>
> On 9/14/2011 10:54 PM, jwcolby wrote:
>> Does anyone have experience with using an SSD (or SSD RAID) to store
>> the Access BEs? Does it significantly speed up the database?
>>
>> My client has a pretty large (by Access standards) database. It is a
>> call center application and they do mostly reads (viewing claim data
>> as they talk to the client), but do a fair amount of "documenting" the
> phone calls by writing notes. About 25 users in the database all day.
>>
>> It seems logical that the SSDs enormous IOPS and streaming reads would
>> speed things up but I have never seen any actual studies or documented
> usage data.
>>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>