Have configured standalone SQL servers with AlwaysOn Availability groups configured for HA. Now when adding two local disks to each server the disks are linked to the clustered storage subsystem not the local one which means I am unable to create a storage pool in Server manager as it states that a minimum if 3 are required to create a cluster storage pool. However I only want to create a local one - not a clustered pool.

Can you please provide a way to either disable the clustered storage subsystem (not need in this config as only a standalone SQL server is installed and I only want to use local disks) or, provide a way to change the link from the clustered storage subsystem to the local storage subsystem

Wanted to advise on this Auto pull of a New Disk in to Storage Pool and options to Get a Disk out of the Pool & back to the local system.

            So far, I’ve checked in MSDN (How-to-remove-disks-from-primordial-pool) but it seems like currently there’s no option to do such;

            My request is for a solution that enables to;

1. Skip disks out of the Pool Collection when enabling S2D.


2. Add new disks to the system with a choice of whether or not to put them in S2D or Pool.


3. Pull an existing disk(s) out of a Primordial Pool.

So far the workarounds (still looking for a better approach) I’ve are;
1. Avoid getting a disk pulled into Storage Space.
 Only when the disk has a volume.
 Works but we should ‘ve something better.
2. Add a disk into Primordial Pool but not to the user defined ones.
 Get-StorageSubSystem Cluster* | Set-StorageHealthSetting -Name "System.Storage.PhysicalDisk.AutoPool.Enabled" -Value False
 Works but we should ‘ve something that allows to keep disks totally out of the S2D thing (when a new disk is added to the system).
3. Configures the system to enable S2D to claim or not claim specific physical disks
 Set-ClusterStorageSpacesDirectDisk
 Still trying but this doesn’t works.

Remove-PhysicalDisk doesn't work as needed in Windows Server 2016 (like in 2012 R2).

We have Scale-Out File Server on Windows Server 2016. One storage pool with tiering and two way mirroring Virtual Disk. We have free space in pool specially for rebuild (size for more then 4 disk failure). We put one disk as Retire and took out from enclosure. Disk was Lost communication and Virtual Disk auto rebuild.
VirtualDisk shows as Healthy and OK and Repair runs without issues.
We add new HDD to enclosure and add it to pool. All looks good, healthy and OK.
But Remove-PhysicalDisk for old Retire disk doesn't work.

PS C:\Users\markadm> Remove-PhysicalDisk –StoragePool $Pool -PhysicalDisks $FailedDisk

Confirm
Are you sure you want to perform this action?
Removing a physical disk will cause problems with the fault tolerance capabilities of the following storage pool: "DHub
Storage Pool".
[Y] Yes [A] Yes to All [N] No [L] No to All [S] Suspend [?] Help (default is "Y"): y
Remove-PhysicalDisk : Failed
Activity ID: {b931fc7b-595d-40d3-8bdf-150061717020}
At line:1 char:1
+ Remove-PhysicalDisk –StoragePool $Pool -PhysicalDisks $FailedDisk
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo          : NotSpecified: (StorageWMI:ROOT/Microsoft/..._StorageCmdlets) [Remove-PhysicalDisk], CimE

xception

+ FullyQualifiedErrorId : StorageWMI 4,Remove-PhysicalDisk

I found same problem on a forum without any resolution: https://social.technet.microsoft.com/Forums/en-US/a7cdd6ce-db9c-47f8-b366-8d0b437a6bb8/removephysicaldisk-fails-with-failover-clustering-and-storage-spaces-in-windows-server-2016?forum=winserverfiles

Currently, a failed disk shows up as a warning level alert in the StorageSpaces-Driver Operational event log.
Can you please add an alert to the dashboard level of Server Manager to indicate that there is degraded storage that needs attention, or perhaps add an Action Center alert?
I know that I can script a scan for that alert in the event log, and script a check for the health status with Get-PhysicalDisk, Get-VirtualDisk and Get-StoragePool.
It would be nice if the default was for Windows to be a little more outgoing about letting us know there was a problem, just in case we are not actively looking for said problem.

I have a 3 node cluster setup and validated for Storage Spaces Direct. Each node has two 1TB SSDs and two 4TB HDDs (total 6 of each) all of which are cleaned of partitions and data (running on Dell HBA330s). All nodes have the required networking in places, are joined in a cluster and are running Server 2016 TP5 with the latest updates. Running cluster validation for Storage Spaces direct comes back with only the warning about 3 node cluster vs 4 (I only want mirrors, so 3 should work).

The problem is no matter what I do I cannot seem to get a proper virtual disk to create. I am trying to create a tiered disk with the SSD space as a hot tier and HDD space as a cold tier, each in a mirror. If I try this from Powershell I get "The storage pool does not have sufficient eligible resources for the creation of the specified virtual disk". From the GUI in failover cluster manager I can get to the Size screen, but the free space readings are always under a few GB and change each time I run the GUI.

Here is what I get on a fresh manual setup via PS:

PS C:> Enable-ClusterStorageSpacesDirect -Autoconfig $false

Confirm
Are you sure you want to perform this action?
Performing operation 'Enable Cluster Storage Spaces Direct' on Target 'IGA-S2D'.
[Y] Yes [A] Yes to All [N] No [L] No to All [S] Suspend [?] Help (default is "Y"): y

PS C:> Get-StorageSubSystem

FriendlyName HealthStatus OperationalStatus

Windows Storage on IGA-S2D1 Healthy OK
Clustered Windows Storage on IGA-S2D Healthy OK

PS C:> New-StoragePool -StorageSubSystemFriendlyName "Clustered Windows Storage on IGA-S2D" -FriendlyName S2D -Provisio
ningTypeDefault Fixed -PhysicalDisk (Get-PhysicalDisk | ? CanPool -eq $true)

FriendlyName OperationalStatus HealthStatus IsPrimordial IsReadOnly

S2D OK Healthy False False

PS C:> $pool = Get-StoragePool S2D
PS C:> $pool | Get-PhysicalDisk | FT FriendlyName,OperationalStatus,HealthStatus,Usage,Size

FriendlyName OperationalStatus HealthStatus Usage Size

ATA Samsung SSD 850 OK Healthy Auto-Select 1024081264640
ATA Samsung SSD 850 OK Healthy Auto-Select 1024081264640
ATA WDC WD4002FYYZ-0 OK Healthy Auto-Select 4000762036224
ATA WDC WD4002FYYZ-0 OK Healthy Auto-Select 4000762036224
ATA Samsung SSD 850 OK Healthy Auto-Select 1024081264640
ATA WDC WD4002FYYZ-0 OK Healthy Auto-Select 4000762036224
ATA WDC WD4002FYYZ-0 OK Healthy Auto-Select 4000762036224
ATA WDC WD4002FYYZ-0 OK Healthy Auto-Select 4000762036224
ATA WDC WD4002FYYZ-0 OK Healthy Auto-Select 4000762036224
ATA Samsung SSD 850 OK Healthy Auto-Select 1024081264640
ATA Samsung SSD 850 OK Healthy Auto-Select 1024081264640
ATA Samsung SSD 850 OK Healthy Auto-Select 1024081264640

PS C:> New-StorageTier -StoragePoolUniqueID ($pool).UniqueID -FriendlyName SSD -MediaType SSD -ResiliencySettingName Mirror

ObjectId : {1}\IGA-S2D\root/Microsoft/Windows/Storage/Providersv2\SPACESStorageTier.ObjectId="{6116563

                     c-31ed-4aa3-a54c-90034eddd5d3}:ST:{72ceedad-fa7c-4e66-9b0a-4c83782c8891}{fd5eeb52-486c-4dd9-8f

                     5c-7b0dfb52dcc8}"

PassThroughClass :
PassThroughIds :
PassThroughNamespace :
PassThroughServer :
UniqueId : {fd5eeb52-486c-4dd9-8f5c-7b0dfb52dcc8}
Description :
FriendlyName : SSD
Interleave : 262144
MediaType : SSD
NumberOfColumns : Auto
NumberOfGroups : 1
PhysicalDiskRedundancy : 1
ResiliencySettingName : Mirror
Size : 0
PSComputerName :

PS C:> New-StorageTier -StoragePoolUniqueID ($pool).UniqueID -FriendlyName HDD -MediaType HDD -ResiliencySettingName Mirror

ObjectId : {1}\IGA-S2D\root/Microsoft/Windows/Storage/Providersv2\SPACESStorageTier.ObjectId="{6116563

                     c-31ed-4aa3-a54c-90034eddd5d3}:ST:{72ceedad-fa7c-4e66-9b0a-4c83782c8891}{a9a4faab-0498-4b98-84

                     d4-950a35778d3c}"

PassThroughClass :
PassThroughIds :
PassThroughNamespace :
PassThroughServer :
UniqueId : {a9a4faab-0498-4b98-84d4-950a35778d3c}
Description :
FriendlyName : HDD
Interleave : 262144
MediaType : HDD
NumberOfColumns : Auto
NumberOfGroups : 1
PhysicalDiskRedundancy : 1
ResiliencySettingName : Mirror
Size : 0
PSComputerName :

PS C:> New-Volume -StoragePool $pool -FriendlyName Mirror -FileSystem CSVFS_REFS -StorageTierFriendlyNames SSD,HDD -Sto
rageTierSizes 10GB, 100GB
Invoke-CimMethod : Not Supported

Extended information:
The storage pool does not have sufficient eligible resources for the creation of the specified virtual disk.

Recommended Actions:
- Choose a combination of FaultDomainAwareness and NumberOfDataCopies (or PhysicalDiskRedundancy) supported by the
storage pool.
- Choose a value for NumberOfColumns that is less than or equal to the number of physical disks in the storage fault
domain selected for the virtual disk.

Activity ID: {5daef213-f30c-4064-9531-a19be278f73c}
At C:\windows\system32\windowspowershell\v1.0\Modules\Storage\StorageScripts.psm1:1047 char:27
+ ... $output = Invoke-CimMethod -CimSession $session -InputObject $pool ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo          : InvalidOperation: (StorageWMI:) [Invoke-CimMethod], CimException

+ FullyQualifiedErrorId : StorageWMI 1,Microsoft.Management.Infrastructure.CimCmdlets.InvokeCimMethodCommand

As you can see there should be more than enough disk space for the requested disk. It does not matter what sizes I use the same thing occurs.

If I allow the Enable-ClusterStorageSpacesDirect to auto configure it created a storage pool with my disks. The only difference is it attempts to assign all of the SSDs as Journal disks, which would be a waste. I still cant create any meaningful virtual disk with the auto-created pool, even if I change the SSDs back to auto from journal (tried both ways).

I have also tried all of this from the Failover cluster manager GUI and the Server Manager GUI. Both report odd free space numbers and even if I request a disk inside of those (1GB tiered disk) it will still fail.