Check Disk Offset using Powershell

Scott Newman Powershell, SQL Server March 27, 2015March 27, 2015 1 Minute

Quick script to make sure your disk partitions are properly aligned for a sql server installation. Read this article for disk partition best practices as to why you should always ensure that your offset is correctly set.

cls

$objects = @();

@('Server1', 'Server2') | %{
	try{
        $srvName = $_
		Get-WmiObject -Class Win32_DiskPartition -ComputerName $srvName | %{
            $objects += [PSCustomObject]@{
                ServerName = $srvName
                DiskName = $_.Name
                StartOffset = $_.StartingOffset 
                Result = if(($_.StartingOffset % 4096) -eq 0){"Partitioned Correctly"}else{"ISSUE"}
            }
		}
	}
	catch{
		$_ | fl -Force
	}
}
$objects | Out-GridView