RAID Configuration with SSD Hard Disks

Question

Hi Team,

I am having a SQL database server with large transactions happening per second. I have configured RAID10 with spindle disks and we are planning to upgrade our servers for high performance. what is the best RAID Configuration with SSD hard disks

Answer 1

Hi AbdulManaf-7382,

Welcome to Microsoft Q&A.
Please check the recommendations in the following links which might be helpful:
RAID Levels and Recommendation for Data and Log Files
RAID 10 array configuration for SQL Server
How should I configure the RAID array of SSD drives on my SQL Server?

Regards,
Amelia

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Has nothing directly to do with SQL Server, that's bare metal.
It depends more on your budget; so you can go with Raid10 as well, or high speed SSD storage solutions.

Answer 3

You should contact your hardware manufacturer. They will have recommendations specific to SQL Server usage for their product.

Answer 4

Thanks Everyone for the wonderful suggestions.
Referring to your suggestions and recommendations from the vendor, for SSD,s we have a different scenario considering the RAID Groups.