Home Forums SQL Server 2008 SQL Server 2008 Administration Are these SQLIO results ok? Need to ensure that new SAN IO latency is topnotch RE: Are these SQLIO results ok? Need to ensure that new SAN IO latency is topnotch

  • December 19, 2012 at 2:07 pm

    #1570304

    sql-lover (12/18/2012)

    Leo.Miller (12/18/2012)

    Looks to me like the disks aren't formatted at 64Kb. I'd definitly check this as there are some gains to be made here.

    Leo

    I am not following you. The 64 KB was specified by me. The test uses 64 and 8KB page sizes.

    I believe he meant the cluster size that the disk is formatted at, not the size of the IO for your test.

    The usual recommendation is that disks that hold SQL Server data files be formatted at 64K.