SQL Server - Drive speed question
Posted on 2014-04-01
Planning a MS SQL server. I would like some inputs/insight regarding storage performance.
I believe that for optimum performance, each of the following should be on separate drives: OS, database, index, logs, tempdb.
If the above statement is correct, and I could only have 1 SSD drive (and the others on spinning drives), which of the 5 should I put on the SSD drive for the best performance?