Disk Partition Alignment Audit

Find Misaligned Disk Partitions in Your Network

Find disk partitions which are misaligned are need correcting. A misaligned disk partition can cause performance issues and it is therefore recommended you resolve these misalignments. Finding misaligned drives can be difficult, especially in a large environment. The audit below provides a list of devices which have misaligned disk partitions so you can take action right away.

Disk Partition Alignment Query

Select Top (1000000) tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysOS.OSname,
  Cast(Round(tblDiskPartition.Size / 1024 / 1024 / 1024, 2, 0) As DECIMAL(20,1))
  As 'Size (GB)',
  'Disk #' + Cast(tblDiskPartition.DiskIndex As Varchar(5)) + ' : Partition #' +
  Cast(tblDiskPartition.[Index] As Varchar(5)) As DeviceID,
  tblDiskPartition.StartingOffset,
  Case
    When (tblDiskPartition.StartingOffset / 4096 !=
    Round(tblDiskPartition.StartingOffset / 4096, 0)) Then 'FALSE' Else 'TRUE'
  End As 'Is Aligned?',
  tsysOS.Image As icon,
  tblAssetCustom.Model
From tblDiskPartition
  Right Join tblAssets On tblDiskPartition.AssetID = tblAssets.AssetID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tblOperatingsystem
    On tblAssets.AssetID = tblOperatingsystem.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblDiskPartition.StartingOffset / 4096 <>
  Round(tblDiskPartition.StartingOffset / 4096, 0) And tblAssetCustom.State = 1
Group By tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysOS.OSname,
  'Disk #' + Cast(tblDiskPartition.DiskIndex As Varchar(5)) + ' : Partition #' +
  Cast(tblDiskPartition.[Index] As Varchar(5)),
  tblDiskPartition.StartingOffset,
  tsysOS.Image,
  tblAssetCustom.Model,
  tblDiskPartition.StartingOffset / 4096,
  tblDiskPartition.Size
Order By tblAssets.AssetName,
  DeviceID