Back in the age of Windows Server 2003, there was a best practice to align disk partitions for SQL Server for performance gain: http://technet.microsoft.com/en-us/library/dd758814(v=sql.100).aspx
This seems old, right? Come on, we are using SQL Server 2014 on Windows Server 2012 R2 now!
Well, yesterday I happened to come across this white paper again and wanted to check one of our new servers and guess what – the cluster size on this new box is using default 4096 bytes instead of 64KB which is a best practice:
(Screenshot was taken on my VM, not the actual production server)
I have decided to blog this so I can remind myself in the future – change the cluster size for SQL Server!