• msimone - Monday, February 27, 2017 2:46 AM

    Hello, i have a doubt.
    What is the best configuration for a raid with ssd?
    My doubt is about the throughput.
    Thanks.

    You are presumably moving from rotating rust storage to SSDs, and you are worried that the RAID type will make things not be game changing? You are clearly not familiar with the performance differences between the two. 🙂

    Your world will be rocked when you change to SSDs for SQL Server storage. I note that things can get BAD doing so though. Deadlocks can become a SERIOUS problem if your app is set up for them. I have seen it so bad that the application had to be rolled back onto slower storage until the deadlock issues could be mitigated.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service