Solved

MS SQL -  (SSD) Drive Recommendations?

Posted on 2011-09-07
10
868 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
  • 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

When we purchase storage, we typically are advertised storage of 500GB, 1TB, 2TB and so on. However, when you actually install it into your computer, your 500GB HDD will actually show up as 465GB. Why? It has to do with the way people and computers…
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
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…

803 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