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
I'm a Sr. Systems Engineer at a Global Environmental Engineering company. I've been in IT since 1999 and from 2005, my focus has been VMware datacenter products. More recently, my attention has been for Microsoft Azure services. As the Global Service Owner for VMware Datacenter products, I've had the pleasure of having in-depth and hands-on experience with not only VMware products, but server, storage and networking technologies.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment