Solved

hdd's vs sshd

Posted on 2016-08-26
14
33 Views
Last Modified: 2016-08-29
hello everybody,

The configuration:
I'm currently running Server 2008 R2 standard with SQL 2008 that is running a software that 25 workstation connect to.  This Server is configured with two hdds mirrored in a raid 1, however one of these hard drives is going bad.

The question:
would it be better to replace the hdds with with ssds to increase performance?
0
Comment
Question by:dtidwell69
14 Comments
 
LVL 22

Assisted Solution

by:Nick Rhode
Nick Rhode earned 125 total points
Comment Utility
If you are having issues with read/write speeds then yes.  SSDs are much faster and do increase performance
0
 
LVL 87

Assisted Solution

by:rindi
rindi earned 125 total points
Comment Utility
It depends. If you are using Windows Software RAID for mirroring, then yes. If you are using a RAID controller, then most probably no, as most RAID controllers don't support TRIM which is needed for SSD's.

You would have to get enterprise class SSD's whether your RAID controller supports TRIM or you are using OS software RAID, and those are still expensive.
1
 

Author Comment

by:dtidwell69
Comment Utility
So are you saying that any Enterprise SSD drive will work under any hardware raid
0
 
LVL 87

Expert Comment

by:rindi
Comment Utility
No. For any SSD you need a RAID controller that supports TRIM (as I said there are only very few such controllers, and they are very expensive). But even if you happen to have such a controller you still need enterprise class SSD's.

If you are using OS integrated RAID, then you could use standard SSD's, but for a server you still need enterprise class SSD's.
0
 
LVL 11

Assisted Solution

by:zalazar
zalazar earned 125 total points
Comment Utility
Could you maybe tell more about the hardware configuration of your server
E.g. server type, raid controller model, hard drive type (including rpm).

If the SQL database is causing a high disk I/O and if you have the option to add more conventional hard drives then you might look at the possibility to move the SQL database data, logfiles, tempdb to new hard drives which will improve disk performance as the disk load will be spread across more disks.
0
 
LVL 23

Expert Comment

by:Dr. Klahn
Comment Utility
Agree with rindi's comments above.  SSDs have their own set of problems, and cliff-edge failure of the entire drive when wear leveling runs out is one of them.  RAIDing SSDs all installed at the same time could conceivably result in the entire RAID set going bad simultaneously.
0
 

Author Comment

by:dtidwell69
Comment Utility
with that said, can you raid 1 an HDD with an SDD
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 87

Expert Comment

by:rindi
Comment Utility
Theoretically yes, but you won't get any advantage out of that, and the SSD will be very short lived. Besides, you'd have to find a capacity that fits your HD.
0
 

Author Comment

by:dtidwell69
Comment Utility
so are you saying that the SSD drive won't last very long? the capacity that my hard drive has is 500 gig the same as the SSD
0
 
LVL 87

Expert Comment

by:rindi
Comment Utility
Yes, the SSD would die very soon. You'd also probably need an SSD with more than 500GB,
0
 

Author Comment

by:dtidwell69
Comment Utility
so how long do you thing the SSD's will last?
0
 
LVL 87

Expert Comment

by:rindi
Comment Utility
Not long. Certainly it isn't worth trying.
0
 
LVL 27

Accepted Solution

by:
serialband earned 125 total points
Comment Utility
That all depends on how heavily used your system is and how big your SSD is.  Newer SSDs have built in garbage collection and can last longer even without proper Trim support.  Trim isn't as necessary for the RAID to support if you have a very low end server that isn't very heavily impacted.

How new is your 2008 R2 server?  Does it support SSDs?  What kind of server hardware is it?  Does it get heavy disk access?  Does it have a separate data drive?  If your SQL data is on a separate drive, you're probably ok with getting SSDs for the boot disk.  Some rack mount servers with hardware RAID actually have a list of drives that they support.  You can't just plug in a random SSD and expect it to work.

If it's old and supports SSDs, and you're just extending the life by a year, then it's probably ok.  If it's getting heavily impacted with disk access, you'd probably want to get proper SSDs and hardware RAID that are meant for that, or just stick with HDs.

Whether you use SSDs or HDs, if you have a system with enough RAM, you can always turn off all disk swap and increase the performance slightly by not putting anything to disk in the first place.  That's assuming your SQL Data is on a separate data disk or that SQL data can all fit into RAM.  I suggest it's safer to stick to HDs if that's not the case..
0
 

Author Closing Comment

by:dtidwell69
Comment Utility
thanks everyone
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Hello to users to the new age of computers. There are so many products to choose from nowadays that you maybe confused to understand which product is the correct product for you. Let me explain briefly what should be the idea product for your best n…
this article is a guided solution for most of the common server issues in server hardware tasks we are facing in our routine job works. the topics in the following article covered are, 1) dell hardware raidlevel (Perc) 2) adding HDD 3) how t…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

728 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now