Thor Logo dbatools

Disk

Get-DbaDiskSpace

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

Get-DbaDiskSpace View Source Chrissy LeMaire (@cl), netnerds.net , Jakob Bindslet Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.

Read more

Test-DbaDiskAlignment

Constantine Kokkinos (@mobileck), constantinekokkinos.com

Test-DbaDiskAlignment View Source Constantine Kokkinos (@mobileck), constantinekokkinos.com Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.

Read more

Test-DbaDiskAllocation

Chrissy LeMaire (@cl), netnerds.net

Test-DbaDiskAllocation View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.

Read more