none
Sense of partitioning disk with different block size

    Question

  • Hi,

    I have to install the MS SQL 2016. Because we are non-for profit clinic and have limited budget our Server would be with one Disk system (RAID 10 with four disks). It will be physical machine (not a VM) Our DB will be small- about 15 GB. I need a suggesting if I am going to setup it with the best configuration for my hardware..

    I am going to Setup one primary DEFAULT partition for OS and SQL Server 2016 program C:\Program Files\MS SQL SERVER. After Installing OS I am going to create a second D:\ partition with 64K block size for DB and log files (MDF and LDF)

    Is my project correct with one disk system? Any improvement would be appreciated

    Thank you in advance.


    • Edited by alilbas Wednesday, April 12, 2017 4:47 PM
    Wednesday, April 12, 2017 4:46 PM

All replies

  • That would probably work, However, You may want to consider adding at least a fifth disk so that you can designate a separate drive (E: ?) for data/log/backup files and setup your RAID array on the four disks making up E. That way, if you lose the single system drive (C: ) for some reason, you can still recover the database(s) or backups a little easier, plus, you only need to format the E: drive as 64KB block size. 

    HTH,


    Phil Streiff, MCDBA, MCITP, MCSA

    • Edited by philfactor Wednesday, April 12, 2017 5:55 PM
    Wednesday, April 12, 2017 5:25 PM
  • A database that size with a single disk array with 4 disks, nothing you do will have a significant effect on the performance. 

    It is always best practice to separate the data from logs from backups.  However, you are sharing a disk either way.

    Wednesday, April 12, 2017 5:30 PM