Best practice for setting up a SQL 2019 Cluster

Question

Experts,

Can you please help with best practices for setting up sql 2019 cluster.

Thanks

Answer 1

Hey,

The following link should help.
https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/always-on-failover-cluster-instances-sql-server?view=sql-server-ver15
SQL FCI requires shared storage to create a Failover Cluster. Check the following guide on how to configure (it covers shared storage configuration):
https://www.starwindsoftware.com/resource-library/starwind-virtual-san-installing-and-configuring-sql-server-2019-tp-failover-cluster-instance-on-windows-server-2016/

Cheers,

Alex Bykovskyi

StarWind Software

Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

Answer 2

Hi @Vishal Garg ,

SQL Server Failover Cluster Instance (FCI) is a SQL Server instance that is installed across nodes in a WSFC. Before installing SQL Server failover cluster, we need to configure Windows Server Failover Clustering (WSFC), and review network, security, and considerations for other software that will run on your failover cluster. Please refer to this doc about requirements and considerations of installing FCI.
And here are articles about step-by-step installing FCI which might help:
Step-by-step Installation of FCI 2019 on a WSFC 2019 Part 1
Part 2
Part 3
Part 4

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Clustering is mainly a Windows feature & functionallity, SQL Server is only a cluster-aware service; so your question is more Windows related.
=>
https://learn.microsoft.com/nl-nl/windows-server/failover-clustering/failover-clustering-overview