Query on storage pools

Glenn Maxwell 10,551 Reputation points
2022-09-01T21:16:00.83+00:00

Hi All
i want to setup SQL cluster, i have provisioned two Azure VMs node1 and node2 which are windows server 2019.
i have not joined the servers to the domain. i have setup three storage pools on each server and each storage pool has 2 disks(simple).
i have joined the servers to domain and i have setup failover cluster manager and added both the nodes. i am using azure storage account as my cloud witness.
When i have added both the nodes to failover cluster manager, in storage pools i can see storage pool is changed from windows storage to clustered storage pool.

i dont want these storage pool to go to clustered storage pool after installing failover cluster manager. i read one article and it tells me to execute the below syntax.

Get-StorageSubsystem -FriendlyName "Clustered" | Set-StorageSubSystem -AutomaticClusteringEnabled $False

When do i need to execute this syntax i.e provision the VMS, install failover cluster manager, add both the nodes, execute this syntax and setup storage pools is it correct?
can i use any name as friendly name.

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,541 questions
Windows Server 2016
Windows Server 2016
A Microsoft server operating system that supports enterprise-level management updated to data storage.
2,417 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,440 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
969 questions
Windows Server Storage
Windows Server Storage
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Storage: The hardware and software system used to retain data for subsequent retrieval.
640 questions
0 comments No comments
{count} votes

Accepted answer
  1. Limitless Technology 39,466 Reputation points
    2022-09-05T07:29:31.037+00:00

    Hello there,

    You should configure the Storage Pools locally on each node before adding the servers into the Windows Server Failover Cluster

    If you are creating a SQL Sever failover cluster instance (FCI) in Azure, you can use Storage Spaces Direct (S2D) and configure Storage Pools to set-up the Cluster Storage.

    Storage Spaces Direct overview https://learn.microsoft.com/en-us/azure-stack/hci/concepts/storage-spaces-direct-overview

    I hope this information helps. If you have any questions please let me know and I will be glad to help you out.

    -------------------------------------------------------------------------------------------------------------------------------------

    --If the reply is helpful, please Upvote and Accept it as an answer--

    0 comments No comments

0 additional answers

Sort by: Most helpful