• rchantler - Tuesday, February 13, 2018 10:23 AM

    We are looking to upgrade to a solid state drives only server.  It will be raided.  Does it make any sense to create logical drives to separate the OS, data, logs and tempdb (as we do with spinning drives) or should we just go for a single logical drive given there are no moving parts?

    If the physical disk (RAID or single disk) is just one, having multiple logical drives won't make a different but slow, not much (probably won't even notice since it's SSD), things down.
    It makes sense to have multiple disks if each logical disk has a physical of it's own.
    You can create the multiple logical disks if you want to "separate" things (OS and SQL, tempdb, data, log - 4 logical disks) but in your case is just for keeping things "tidy"...



    If you need to work better, try working less...