Reading Time: < 1 minute

By following the next steps you are able to create storage pools for a SQL Server installation.

Storage Pool Best Practices

  • Column Size = Number Of Disks In The Storage Pool, example 2 Disks = Column Size 2
  • Interleave = For OLTP Best is 256KB , For TSQL Best is 64K
  • Allocation Unit Size = For SQL Server Best is  64K Cluster Size

PowerShell Commands To View Useful Information’s For Storage Pools and Virtual Disks

Get-StoragePoolGet-VirtualDisk | Format-List

 

Steps for Storage – Pool with virtual disks

Create storage pool

$Disks = (Get-PhysicalDisk -CanPool $true)
New-StoragePool -FriendlyName -StorageSubsystemFriendlyName "Storage Spaces" -PhysicalDisks $Disks

 

Create Virtual Disks

New-VirtualDisk –FriendlyName SQL_VirtualDisks -ResiliencySettingName Simple –NumberOfColumns 2 –UseMaximumSize –Interleave 256KB -StoragePoolFriendlyName SQL_Server

 

Format Virtual Disks for SQL Server Installation

Get-VirtualDisk –FriendlyName SQL_VirtualDisks | Get-Disk | Initialize-Disk –Passthru | New-Partition –AssignDriveLetter –UseMaximumSize | Format-Volume –AllocationUnitSize 65536

 

Share This