I'm sure there's a wadge of you out there with these toys. How are they standing up to use? Any signs of them coming to the end of their lifespan?

Roy Lambert

Hi Roy,

I have had mine for about 2 years now as my second drive that I store my
working data and all of my program source code on, so it gets a fair
hammering every day. (The database contains DBISAM version 4 tables with
some of them containing upto 350,000 records that get updated weekly)

I have had no problems with it what so ever!

I have had it so long I cannot even remeber what it is but Windows
device manager reports it as being:

MTRON MSD-SATA3535 (32GB)

Hope this helps.


Chris Holland
[Team Elevate]

On 02/09/2013 10:52, Roy Lambert wrote:
> I'm sure there's a wadge of you out there with these toys. How are they standing up to use? Any signs of them coming to the end of their lifespan?
>
> Roy Lambert
>

Roy,

I have SSD's in all my computers (laptops and desktop pc's): no problems
at all.
And the speed is great!

Uli

I currently have about 4 in use (laptops and main desktop) and oldest is
approx 2 years old.

No issues so far but I do daily backups of everything of value as i know
from past experience that any drive will fail at most inconvenient time
whether its SSD or not.

Models a mix of : OCZ Agility, Kingston SSDNow v300 and couple of
Samsung 840 PROs. All work just fine but if i had to recommend i really
like the 840 PRO models - no issues and fast.

Raul


On 9/2/2013 5:52 AM, Roy Lambert wrote:
> I'm sure there's a wadge of you out there with these toys. How are they standing up to use? Any signs of them coming to the end of their lifespan?
>
> Roy Lambert
>

For those people who use it.  Do they really improve database applications in terms of speed and performance?  I need to recommend them for my customers.

Regards,
Abdulaziz Jasser

They definitely improve disk based operations significantly (mostly as
there is no disk seeking, operations can can be parallelized i believe).

You'd only see improvement if your current app workload is disk-bound
though so don't expect miracles. We ran some informal tests with out app
and saw anything from non-improvement to 400%.

Generally RAM and SSD are the best upgrades you can make today - and
both are now very cheap so it's almost a no-brainier to recommend.

The main downsides are reliability - especially for 24/7 workloads - so
ideally you'd go with enterprise grade SSD (lot more $$$$) and get
multiple and put in Raid 1/10 as well as have a spare(s).

We generally recommend them in conjunction with regular drives: have the
SSD as 2nd disk and run databases off it. back it up regularly and make
another backup to main hard drive so in worst case we can just
reconfigure and use the data from main drive (if SSD is dead).


Raul



On 9/2/2013 1:23 PM, Abdulaziz Jasser wrote:
> For those people who use it.  Do they really improve database applications in terms of speed and performance?  I need to recommend them for my customers.