Found ideal block size with SQLIO, what now?

  • Lets say ive run extensive tests with SQLIO and found for my particular workload the ideal blocksize is 64kb.

    I ran the command fsutil fsinfo ntfsinfo T: and can see the drive currently has a cluster size of 4kb.

    Should i now reformat the drive with a cluster size of 64kb?

    Im pretty sure thats what i do, but i just want to be certain.

  • As far as I know you need to reformat the disk.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • Also, Depending on the size of the disk you may want to consider using GPT over MBR.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply