dbatools is a free PowerShell module with over 180 SQL Server administration, best practice and migration commands included.


Test-DbaDiskAllocation

Checks all disks on a computer to see if they are formatted to 64k. Returns $true or $false by default for one server. Returns Server name and IsBestPractice for more than one server.

Specify -Detailed for details about successes and failures.

Screenshots

Test-DbaDiskAllocation

Examples

To return true or false for any disk not being formatted to 64k

Test-DbaDiskAllocation -ComputerName sqlserver2014a

To return detailed information about disks containing SQL data from any instance being formatted to 64k

Test-DbaDiskAllocation -ComputerName sqlserver2014 -Detailed

To return true or false for ALL disks being formatted to 64k

Test-DbaDiskAllocation -ComputerName sqlserver2014a -NoSqlCheck

References

Disk Partition Alignment Best Practices for SQL Server – “The performance question here is usually not one of correlation per the formula, but whether the cluster size ..has been explicitly defined at 64 KB, which is a best practice for SQL Server.”

Configuring Disks in Azure for More Performance

Get-Help

From PowerShell, execute Get-Help Test-DbaDiskAllocation -Detailed for more information on this function.

Source Code

Want to see the source code? View Test-DbaDiskAllocation.ps1 on GitHub
 

Related commands