Create VM SQL cluster storage

Question

Hi,

I have a 2022 3 windows host server cluster connected to a netapp SAN and i have created all CSV's and added storage from the SAN to the cluster and all working and failover works as expected. Now I need to create a VM SQL cluster but i need advice on how i can connect storage from the SAN for the cluster. Do I need to create separate LUNs on the SAN directly and then connect these to the SQL cluster directly for the cluster disks or is there a better way of adding the storage to the SQL cluster. I just need to make sure that if i need to failover the SQL cluster everything stays working as expected.

Answer 1

Hello there,

To install a failover cluster, you must use a domain account with local administrator rights, permission to log on as a service, and to act as part of the operating system on all nodes in the failover cluster.

This article teaches you how to configure your storage for your SQL Server on Azure Virtual Machines (VMs).

SQL Server VMs deployed through marketplace images automatically follow default storage best practices which can be modified during deployment. Some of these configuration settings can be changed after deployment.

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/storage-configuration?view=azuresql&tabs=windows2016

Hope this resolves your Query !!

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