Partition Alignment for SQL Server in Windows 2008.
Default Partition offset with Windows Server 2008 is 1024 KB. For systems from which high performance is required, it is essential to experiment with representative workloads and determine the validity… Read more »