Partition Alignment In Storage

Wayne Sheffield has an article on I/O partition alignment:

What we need to do is to offset the beginning of the data being stored on disk to a location more conducive to how the program is operating. This offset is known as the “Partition Alignment Offset”. To be in tune with SQL Server, this value should be an increment of 64KB. However, you also need to consider the entire storage subsystem – the disks, controllers and memory. Starting with Windows Server 2008, this offset is at 1024KB – a nice increment of 64KB that also works very nicely with most RAID disks/controllers. Prior to Windows Server 2008, partition alignment offset was not explicitly performed, so this will need to be performed.

If you’ve migrated disk from server to server to server over the years, this is worth checking out.

Related Posts

Getting Per-Table Space Utilization With Powershell

Drew Furgiuele provides us a script and a homework assignment: Of course, PowerShell excels at this. By using the SQL Server module, it’s really easy to: Connect to an instance and collect every user database, and From each database, collect every table, and For each table, collect row counts and space used, and If there are […]

Read More

SQL Server Disk Space Analysis

Jana Sattainathan has a solution using Powershell, Power BI, and T-SQL to track disk usage across a series of SQL Server instances: This is just great on its own as I get information shown below. It is basically data like this at the Database/FileGroup/File levels Database/Filegroup/File name Size Free size Max size Free of Max […]

Read More


August 2016
« Jul Sep »