http://blogs.msdn.com/boduff/archive/2008/01/26/improving-sql-disk-performance-1-partition-alignment.aspxThere is a great article that you should read before configuring a disk subsystem for SQL Server. Predeployment I/O Best Practices . As mentioned, one of the common pitfalls is not ensuring that the offset of the first block is &quot;64k&quot; or a multipleen-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/boduff/archive/2008/01/26/improving-sql-disk-performance-1-partition-alignment.aspx#7260018Sun, 27 Jan 2008 00:34:33 GMT91d46819-8472-40ad-a661-2c78acb4018c:7260018MSDN Blog Postings » Improving SQL Disk Performance #1 Partition Alignment<p>PingBack from <a rel="nofollow" target="_new" href="http://msdnrss.thecoderblogs.com/2008/01/26/improving-sql-disk-performance-1-partition-alignment/">http://msdnrss.thecoderblogs.com/2008/01/26/improving-sql-disk-performance-1-partition-alignment/</a></p>http://blogs.msdn.com/boduff/archive/2008/01/26/improving-sql-disk-performance-1-partition-alignment.aspx#8351450Wed, 02 Apr 2008 17:06:05 GMT91d46819-8472-40ad-a661-2c78acb4018c:8351450Bennett Scharf<p>Thank you for the posting. &nbsp;That WMI script is really handy. &nbsp;</p> <p>I found a couple of related articles that may be of interest: &nbsp;</p> <p>For those using EMC SAN storage there is an engineering whitepaper titled &quot;Using diskpar and diskpart to align partitions on Windows basic and dynamic disks&quot;. </p> <p>The Predeployment I/O Best Practices article references another Technet article that really gets into the specifics of aligning partitions: <a rel="nofollow" target="_new" href="http://support.microsoft.com/kb/929491">http://support.microsoft.com/kb/929491</a></p>http://blogs.msdn.com/boduff/archive/2008/01/26/improving-sql-disk-performance-1-partition-alignment.aspx#8991954Wed, 08 Oct 2008 23:01:43 GMT91d46819-8472-40ad-a661-2c78acb4018c:8991954Kevin Kline<p>Kevin talks about the little known but very important issue of disk alignment partitioning.</p> http://blogs.msdn.com/boduff/archive/2008/01/26/improving-sql-disk-performance-1-partition-alignment.aspx#8992388Thu, 09 Oct 2008 06:13:17 GMT91d46819-8472-40ad-a661-2c78acb4018c:8992388Kevin Kline<p>Kevin talks about the little known but very important issue of disk alignment partitioning.</p> http://blogs.msdn.com/boduff/archive/2008/01/26/improving-sql-disk-performance-1-partition-alignment.aspx#9006581Sun, 19 Oct 2008 22:34:24 GMT91d46819-8472-40ad-a661-2c78acb4018c:9006581Alexander Gladchenko<p>Недавно Кевин Кляйн в очередной раз поднял тему выравнивания размеров кластера и блока, проблему, которая</p> http://blogs.msdn.com/boduff/archive/2008/01/26/improving-sql-disk-performance-1-partition-alignment.aspx#9070042Fri, 14 Nov 2008 16:24:32 GMT91d46819-8472-40ad-a661-2c78acb4018c:9070042Alexander Gladchenko<p>Недавно Кевин Кляйн в очередной раз поднял тему выравнивания размеров кластера и блока, проблему, которая</p> http://blogs.msdn.com/boduff/archive/2008/01/26/improving-sql-disk-performance-1-partition-alignment.aspx#9382684Thu, 29 Jan 2009 10:31:58 GMT91d46819-8472-40ad-a661-2c78acb4018c:9382684Alexander Gladchenko<p>Недавно Кевин Кляйн в очередной раз поднял тему выравнивания размеров кластера и блока, проблему, которая</p> http://blogs.msdn.com/boduff/archive/2008/01/26/improving-sql-disk-performance-1-partition-alignment.aspx#9901791Thu, 01 Oct 2009 14:57:10 GMT91d46819-8472-40ad-a661-2c78acb4018c:9901791Declan Corcoran<p>wmic partition get BlockSize, StartingOffset, Name, Index</p>