Monday, August 12, 2013

How to Find the File Allocation Unit Size reported in Bytes Per Cluster: fsutil

For most installations of SQL server, the SQL data and log files should reside on partitions with a 65,536 Byte (64KB) file allocation unit size/cluster size.  Cluster size is determined when the partition is first formatted.  By default, it's set to 4K.

In the past, I was using chkdsk to find the allocation unit size.  However, it takes a while to run...

To quickly find the current value for Bytes Per cluster, run the following command:

fsutil fsinfo ntfsinfo d:        
(Enter the appropriate drive letter for your environment)


For additional info on SQL Disk best practices:
http://msdn.microsoft.com/en-us/library/dd758814.aspx

No comments:

Post a Comment