Check Block Formatting Size for SQL Server

Ever want to quickly check to make sure you formatted that volume correctly for SQL Server with 64K Blocks. Run the following command in Powershell

Get-CimInstance -ClassName Win32_Volume | Select-Object Label, BlockSize | Format-Table -AutoSize

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *