Solved

MS SQL -  (SSD) Drive Recommendations?

Posted on 2011-09-07
10
880 Views
Last Modified: 2012-05-12
OK, I've got 24 kingston 128 GB SSD drives currently in my DB server (in RAID) and I am looking to swap them out.  I don't trust these drives, I've had multiple fail (in other arrays, luckily).  

So, i'm looking for some enterprise level SSD's (I'm not against platter drives at all, but my 24 drive enclosure is for 2.5" drives), damn the expense.  My criteria is the following (in order of importance)
1. Reliability - I need the most reliable drives out there
2. Speed
3. Size (min 128GB)

As of now, cost isn't a big deal, our organization is willing to spend a pretty penny to reduce the chance of a drive failure.
0
Comment
Question by:JamesonJendreas
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 3
10 Comments
 
LVL 55

Accepted Solution

by:
andyalder earned 250 total points
ID: 36498733
Why separate the NAND flash from the server with relatively low bandwidth SAS or SATA cable? If you've got the money get PCIe based SSD - http://www.fusionio.com/products/ Your server manufacture may already partner with them.
0
 
LVL 55

Expert Comment

by:andyalder
ID: 36498764
More info here - http://h18000.www1.hp.com/products/quickspecs/13220_na/13220_na.HTML (blade version of the card but was easier to find, 3 years for all devices, based on a 3.65 TB write & erase per day usage model. 1 in 1020 probability of uncorrectable data and a 1 in 1030 probability of undetected bad data.)

0
 
LVL 1

Author Comment

by:JamesonJendreas
ID: 36498945
@andy - I've been looking at FusionIO, and we use both Dell and Supermicro, but I can't really seem to find any seller that's sells them stand alone.  
0
The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

 
LVL 1

Author Comment

by:JamesonJendreas
ID: 36499068
Ohh and I mentioned minimum 128GB, but that's per drive, I need a RAID array, with redunancy that's at least 1TB (RAID 10 if possible)
0
 
LVL 2

Assisted Solution

by:McRonis
McRonis earned 250 total points
ID: 36499314
Hi!
If money is not a concern, then you could use 2.5" Seagate Savio 15K RPM SAS HDD, they got like 400 IOPS in IOMeter.
Option #2: You could use Intel or Crucial M4 SSD drives, they are very reliable, a lot of IOPS and very fast.
If you want to know how good are these drives - take a look in newegg, there are plenty of reviews.
0
 
LVL 1

Author Comment

by:JamesonJendreas
ID: 36499452
Thank McRonis,
Happy to see you suggested the crucial M4, those are currently what I've been looking at (fast and, well, a name like crucial...).  I was pushing for SAS platter drives, but it looks like they want to stay with SSD's (at the recommendation from our ERP techs)
0
 
LVL 55

Expert Comment

by:andyalder
ID: 36499540
400 IOPS from spinning rusty disk? Someone's tweaked that by turning the write cache on or getting lucky with a hybrid drive. Seagate don't claim anywhere near 400 IOPS for a Savvio.
0
 
LVL 2

Expert Comment

by:McRonis
ID: 36501055
In this link are IOMeter benchmarks with SAS 10k, 15k RPM drives. By the way, 15k 2.5" SAS are pretty fast.
0
 
LVL 2

Expert Comment

by:McRonis
ID: 36501115
With new firmware update, Crucial M4 SSD have the same speed as Sandforce controlled SSD, like OCZ verterx 3 .
So Crucial is making one of the best SSD available to users.
http://www.bit-tech.net/hardware/storage/2011/09/08/crucial-m4-vs-vertex-3-new-firmware-face-of/1
0
 
LVL 55

Expert Comment

by:andyalder
ID: 36501167
Har har, they used Vista for those "benchmarks" so both the OS cache and the disk cache were turned on. Bloody amateurs.
0

Featured Post

Turn Insights Into Action

You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.

With xMatters, you'll never miss a beat.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Each year, investment in cloud platforms grows more than 20% (https://www.immun.io/hubfs/Immunio_2016/Content/Marketing/Cloud-Security-Report-2016.pdf?submissionGuid=a8d80a00-6fee-4b85-81db-a4e28f681762) as an increasing number of companies begin to…
Many businesses neglect disaster recovery and treat it as an after-thought. I can tell you first hand that data will be lost, hard drives die, servers will be hacked, and careless (or malicious) employees can ruin your data.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question