Found ideal block size with SQLIO, what now?

• winston Smith

  SSCoach

  Points: 19500

  More actions

  November 23, 2011 at 2:06 pm

  #246746

  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: 182293

  More actions

  December 27, 2011 at 11:53 am

  #1425822

  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: 234040

  More actions

  January 8, 2012 at 2:35 am

  #1430121

  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"