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'm talking about the actuall formatting of the drives, By default most sysadmins who build serves use the default drive format allocation unit which is 4Kb. If you run >fsutil fsinfo ntfsinfo X: from a command line (whereX is a drive letter) you will get the drive information. You are interested in the line: Bytes Per Cluster : If it says 4096 it is formated with 4Kb allocation units. You want this to say 65536 i.e. 64Kb. This can make a noticable change in disk performance.
You may need to reformat your data dives, in which case you may need to backup your data. If you've been carefull and kept the system DBs apart from the user DBs you can backup and then restore the databases after reformatting.
Cheers
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.