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


Test-SqlDiskAllocation

This command checks all disks on a computer to see if they are formatted to 64k, which is SQL Server Best Practice (8k page x 8 = 64k extent).

References

Microsoft – “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 SQL Disks for More Performance

Examples

To return true or false for disks containing SQL data from any instance being formatted to 64k

Test-SqlDiskAllocation -ComputerName sqlserver2014a

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

Test-SqlDiskAllocation -ComputerName sqlserver2014a -NoSqlCheck

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

Test-SqlDiskAllocation -ComputerName sqlserver2014a, sqlcluster -Detailed

Get-Help

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

Source Code

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

Related commands