How to extend existing storage pool in cluster

Question

Hi,

We are trying to extend the storage pool in a Windows Clustered Storage.

The "Always On availability groups" feature is enabled on two VMs.

This should be automated. The following commands are working on a single SQL Server (not in a cluster).

But it doesn't seem to work on SQL Server AlwaysOn instances. Why is that?

$physicalDisksToAdd = Get-PhysicalDisk -CanPool $True

$physicalDisksToAdd

Number FriendlyName SerialNumber MediaType CanPool OperationalStatus HealthStatus Usage Size

---

7 Msft Virtual Disk Unspecified True OK Healthy Auto-Select 200 GB

$targetLUN = "3"

$targetLUN

3

$physicalDiskToAdd = $physicalDisksToAdd | Where-Object { $_.PhysicalLocation -match "LUN\s*$targetLUN" }

$physicalDiskToAdd

Number FriendlyName SerialNumber MediaType CanPool OperationalStatus HealthStatus Usage Size

---

7 Msft Virtual Disk Unspecified True OK Healthy Auto-Select 200 GB

$storagePool = Get-StoragePool -FriendlyName "SQLVMStoragePool1" | Select-Object -first 1

$storagePool

FriendlyName OperationalStatus HealthStatus IsPrimordial IsReadOnly Size AllocatedSize

---

SQLVMStoragePool1 OK Healthy False False 255.48 GB 255.25 GB

Add-PhysicalDisk -StoragePoolFriendlyName $storagePool.FriendlyName -PhysicalDisks $physicalDiskToAdd

Add-PhysicalDisk : One or more parameter values passed to the method were invalid.

At line:1 char:1

• Add-PhysicalDisk -StoragePoolFriendlyName $storagePool.FriendlyName - ...

• 
      + CategoryInfo          : InvalidArgument: (PS\_StorageCmdlets:ROOT/Microsoft/...\_StorageCmdlets) [Add-PhysicalDisk 
  
     ], CimException 
  
      + FullyQualifiedErrorId : MI RESULT 4,Add-PhysicalDisk
  

Answer 1

Hello,

Thank you for posting in Microsoft Support Community. Based on the description, I understand your question is related to SQL Server AlwaysOn.

Since SQL Server AlwaysOn is not currently supported in the Microsoft Support Community, it is recommended to repost your question in Microsoft Q&A, where dedicated engineers will provide you with professional and effective answers.

https://learn.microsoft.com/en-us/answers/questions/

Thank you for your understanding and support. If you have any question or concern, please feel free to let us know.

Answer 2

Hi,

Thank you for the answer.

We have tried 3 times to post the question in Microsoft Q&A. But got 404 error there.

Answer 3

It could be a temporary problem with the site. It works fine on my end. You can give another try later.