Share via

RAID Configuration with SSD Hard Disks

Abdul Manaf 21 Reputation points
2022-02-17T05:18:29.447+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,629 questions
Accepted answer
  1. AmeliaGu-MSFT 13,976 Reputation points Microsoft Vendor
    2022-02-17T07:38:50.94+00:00

    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.

    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 43,901 Reputation points
    2022-02-17T07:32:30.047+00:00

    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.

    0 comments
  2. Tom Phillips 17,731 Reputation points
    2022-02-17T13:59:55.373+00:00

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

    0 comments
  3. Abdul Manaf 21 Reputation points
    2022-02-21T07:59:54.62+00:00

    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.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.