On 2/7/10 1:59 PM, Bobby Heid wrote:
> Hey,
>
>
>
> The default allocation unit size is usually 4K. I have a drive that I store
> only my recorded shows on. Would I benefit any by change the allocation
> unit size to a larger number? If so, what setting would be best? The
> smallest files average about .8GB and go up to about 8-9GB.
>
>
I have worked with a lot of customers on this (on enterprise class
storage, www.xivstorage.com).
Most MS SQL admins have no idea that Microsoft's recommended best
practices is 64KB NTFS cluster to match the MS SQL extent size. I have
seen a 300% performance improvement going from 4KB to 64KB.
Large clusters will help insure larger IO on large files. Depending on
your file types, and use, it can help a little, or a lot.
Cache Data bases, for example read/write in 8KB units, and thus work
best with an 8KB cluster size.
Harry
> Thanks,
>
> Bobby
>
>
