Found ideal block size with SQLIO, what now?

  • winston Smith

    SSCoach

    Points: 19484

    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.

  • Orlando Colamatteo

    SSC Guru

    Points: 182268

    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

  • Perry Whittle

    SSC Guru

    Points: 233784

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

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

    [font="Tahoma"]"Ya can't make an omelette without breaking just a few eggs"[/font] 😉

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

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