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