Avatar of Daniel Tidwell
Daniel Tidwell
 asked on

hdd's vs sshd

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?
Hardware

Avatar of undefined
Last Comment
Daniel Tidwell

8/22/2022 - Mon
SOLUTION
Nick Rhode

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
rindi

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Daniel Tidwell

ASKER
So are you saying that any Enterprise SSD drive will work under any hardware raid
rindi

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.
SOLUTION
zalazar

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Dr. Klahn

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.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Daniel Tidwell

ASKER
with that said, can you raid 1 an HDD with an SDD
rindi

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.
Daniel Tidwell

ASKER
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
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
rindi

Yes, the SSD would die very soon. You'd also probably need an SSD with more than 500GB,
Daniel Tidwell

ASKER
so how long do you thing the SSD's will last?
rindi

Not long. Certainly it isn't worth trying.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER CERTIFIED SOLUTION
serialband

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Daniel Tidwell

ASKER
thanks everyone