Discover what’s new in Lansweeper – Explore our 2024 Summer Launch! 🚀 Learn more

TRY NOW

Disk Partition Alignment Audit

Hardware Hardware Components

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.
This audit can only be run on SQL Server installations.
Disk Partition Alignment

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

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.