Editorials

SSD Maturation

Webcast: Understanding the new culture of SharePoint
You have a sponsor for SharePoint development, you have a budget, now where are all the users? Online Collaboration powered by SharePoint is not only a new technology, but a new culture of doing work. In this session we’ll explore change management (the fluffy kind) strategies that can be tailored to your user base. Attract users, and keep your budget!

Presented by: Adam Levithan

> Register Now
> Live date: 7/28/2010 at 12:00 Pacific

SSD Maturation

George reminds us that technology and capabilities and cost are always changing.

My research into SSD was limited to looking into two sources…a single large scale SSD vendor where 500Gig runs into many thousands of dollars. The second source was simply Amazon.Com looking at retail SSD you might buy for your personal computer as direct attached disk. Those prices ranged from $300 to $1,000 dollars. I didn’t look into the current performance of the drive regarding lifetime.

So, I am grateful to all of our readers who have responded with personal experience…you really are the ones with the expertise here. Some responded with negative experiences…very expensive SSD that died in 3 months of usage. Others had extremely great success with SSD. None really provided a time frame of their experience; so, it is difficult to establish if that experience was during early versions of a developing technology.

One thing that has been confirmed is that even current SSD technology does not have the same lifetime of a physical disk. That doesn’t mean it is not a good candidate for use…it just means it may not be applicable to any and all applications.

Following is George’s response in detail…thanks for the input George.

Drop me a note if you have current insight into SSD and how it can be used effectively with your database or application. Send your response to btaylor@sswug.org.

Cheers,

Ben

George writes:

I was shocked to see you talking about SSDs without having really investigated the state of the technology TODAY. Your analysis was akin to someone saying "You can’t buy a hard drive bigger than 150 MB, at least that was the limit the last time I looked several years ago. I don’t know if anything has changed there."

The latest SSDs have advanced wear leveling algorithms to prevent the issue of wearing cells in the drive.

They don’t cost anywhere near what you sited in your previous article nor in the latest one.

There are two types: SLC and MLC drives the former are more expensive, but are more robust. The later are cheaper, but even those have 3 year warranties. If you do the math on them, like sites such as Tomshardware.com have, you will find that they are good for at least 20 years with hard use!

Check out the latest OCZ Revo Drives: 2,000,000 hrs MTBF
3 years parts and labour warranty
540 MBPs Sequential Read
490 MBPs Sequential Write
75,000 IOPS
PCI-E x4 slot

A 120 GB drives retails for $369, a 240 GB drive for $720 and a 480 GB drive for around $1400.

On the high end, the SLC based 512GB PCI-E x8 ZDrive R2 has 1.4 GBPS Read and Write and 10,000,000 hours MTBF.

OCZTechnology.com is a good place to start looking – they are known for being spot on in terms of what they claim their products can do. I am not in any way connected to them. Just know what’s what. Their products rock and blow away mechanical hard drives.

From an environmental point of view, they pay for themselves with greatly reduced power consumption too!

All the best;

George

Featured Article(s)
SQL Server 2005 AWS — Part 1
SQL Server 2005 AWS — Part 1