• rchantler - Monday, March 5, 2018 10:36 AM

    Thanks PiMané.
    Re the logical drives, I think with one platter I'd just organize the various pieces into folders.  That way if we add a drive the space will become available to any/all folders; there won't be a need to manage space on separate drives, i.e. space on C: vs space on D:, etc.

    A more interesting question is probably how to organize say 16 solid state drives on the server.  One large physical drive, or a physical C:, D:, E: and F: ?  I.e. separate physical RAID arrays for system, data, logs and tempdb or one large raid array and folders for organization?

    In my mind it would come down to speed, i.e. is there a speed advantage to having separate RAID versus one big RAID when all the drives are solid state?

    Separate physical disks is always better...
    With 16 disks you can have 4 physical RAID 10 (4 disks per RAID) partitions that is the best system for databases, but since SSDs are extremely fast I would go with RAID 1 (2 disks) for OS and SQL Server installation, RAID 1 (2 disks) for tempdb, if you tempdb is not very intensive writing, and RAID 10 (with 8 disks) for database files. 
    Having just one big RAID 10 with 16 disks won't make much of a difference in performance but with separate RAID you can "keep the house clean"... But either way you are good...



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