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