• Did you grow your database file before the physical defragmentation to prevent future fragmentation on the volume for the database files? What was the down time? Was another defragment tool utilized that could do this while the database was up and had throttling control?

    Also curious for those knowing the answer just for verification purpose but: if you have two files and each one has 1 split, then isn't the volume at 100% file fragmentation? A database file would then show as completely fragmented? Just curious if anyone knows this one.

    Example:

    Two files take up an entire volume. Each file is split once.

    On disk the files are written like this:

    Half of file A | Half of file B | Second half of file A | Second half of file B

    100% Disk fragmentation (assuming the files take up the entire disk) and 100% file fragmentation?