Disk

Get-DbaDiskSpace

Chrissy LeMaire (@cl), netnerds.net | Jakob Bindslet

Get-DbaDiskSpace View Source Chrissy LeMaire (@cl), netnerds.net , Jakob Bindslet Windows, Linux, macOS Synopsis Retrieves disk space and filesystem details from SQL Server host systems for capacity monitoring and performance analysis. Description Queries Windows disk volumes on SQL Server systems using WMI to gather critical storage information for database administration. Returns comprehensive disk details including capacity, free space, filesystem type, and optional fragmentation analysis. Essential for SQL Server capacity planning, this function helps DBAs monitor disk space before growth limits impact database operations.

Test-DbaDiskAlignment

Constantine Kokkinos (@mobileck), constantinekokkinos.com

Test-DbaDiskAlignment View Source Constantine Kokkinos (@mobileck), constantinekokkinos.com Windows, Linux, macOS Synopsis Tests disk partition alignment to identify I/O performance issues that can impact SQL Server. Description Tests disk partition alignment by checking if partition starting offsets align properly with common stripe unit sizes (64KB, 128KB, 256KB, 512KB, 1024KB). Misaligned disk partitions can cause significant SQL Server I/O performance degradation, particularly on high-transaction systems. The function connects to Windows computers via CIM and examines each disk partition’s starting offset.

Test-DbaDiskAllocation

Chrissy LeMaire (@cl), netnerds.net

Test-DbaDiskAllocation View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Validates disk allocation unit sizes against SQL Server best practice recommendations. Description Examines all NTFS volumes on target servers to verify they are formatted with 64KB allocation units, which is the recommended cluster size for optimal SQL Server performance. When checking a single server, returns a simple true/false result. For multiple servers, returns detailed information including server name, disk details, and compliance status for each volume.