Home Forums SQL Server 2012 SQL 2012 - General SSD + HDD Server, where I install os, sql binaries, mdf, ldf and tempDB? RE: SSD + HDD Server, where I install os, sql binaries, mdf, ldf and tempDB?

  • Thank you very much Vladimir,

    I will try to do all of this work. But which is the "theoretical best placement" for the files, according I already have the OS installed on the HDD.

    I think the best I can do is:

    HDD:

    C:\ OS, SQL Sever binaries and other soft.

    D:\ TempDB (in a different logical drive to avoid an uncontrolled growth crashes the OS)

    SSD:

    S:\ MDF and LDF. Formatted at 8Kb or 64kb?

    What do you think? Or is better to keep MDF alone on the SSD, and put LDF on another logical drive E:\ in HDD (because of almost same sequential speed of SSD, and no volatility)?

    Thank you again,