I am all confused by disk alignment, partiton offset.Why do we need to calcualte offset which most of the articles talk about, This is from White Paper
Disk Partition Alignment Best Practices for SQL Server
where its stressed that
Partition_Offset ÷ Stripe_Unit_Size-- should be an integer
'The performance question here is usually not one of correlation per the formula, but whether the cluster size is the NTFS default of 4,096 bytes or has been explicitly defined at 64 KB, which is a best practice for SQL Server.'
Also how do we calculate Stripe Unit Size for SAN.
Thanks all for your replies !!
View Complete Post