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.

This audit can only be run on SQL Server installations.

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

Audit and Take Action in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting