Hello,

It's not easy 🙂 because you have very limited options; the theory is simple - separate the sequential and random I/O, 64 KB formatting for MDF and default formatting for LDF.

I would recommend to split the MDF and LDF files of all databases including tempdb, it sounds me more important than separated location of the tempdb database.

C:\ OS, SQL Server binaries

D:\ MDF files + 64 KB formatting (not sure about the formatting, because I haven't used before the Windows logical partitions with different formatting options. The OS is already installed, may be better to try OS and LDF on SSD with 8 KB formatting and MDF files on the entire HDD drive with 64 KB formatting ). To avoid an uncontrolled growth of tempdb database you can restrict the size of the database and control the database size on the daily basis.

S:\ LDF files +8KB formatting. (I still have some concerns regarding the OLTP databases on SSD solutions. During the last month I have tested the performance of EMC VNX machine which has the mix of SSD and normal drives.I was very impressed with the reading performance of the storage, but I was not happy with the writing performance, maybe because of the preinstalled RAID6; finally we have asked the EMC support to help us to reconfigure the storage. )

And do the load test on your system

How about the backup strategy and backup locations? Are you planning to use the external or local location?

Thanks,

Vladimir