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
Sql Server Powershell 
Leave a comment