Best Practice for AlwaysOn and FCI

Question

Experts , Can you please help share best practices for implementing AlwaysOn Availability Group and FCI for SQL 2019

Answer 1

Before install failover cluster, you must select the hardware and the operating system on which SQL Server will run: https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/install/before-installing-failover-clustering?view=sql-server-ver15

Create and configure a failover cluster instance: https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/install/sql-server-failover-cluster-installation?view=sql-server-ver15

Install or upgrade a SQL Server failover cluster instance: https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/install/create-a-new-sql-server-failover-cluster-setup?view=sql-server-ver15

Considerations for deploying Always On availability groups: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/prereqs-restrictions-recommendations-always-on-availability?view=sql-server-ver15

The steps for configure instance of SQL Server to support Always On availability groups: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/getting-started-with-always-on-availability-groups-sql-server?view=sql-server-ver15

Reference for the creation and configuration of Always On availability groups: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/creation-and-configuration-of-availability-groups-sql-server?view=sql-server-ver15

Answer 2

Hey,

Just adding more information.
Check the following article to understand FCI and AG and how you can use them together:
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-clustering-and-always-on-availability-groups-sql-server?view=sql-server-ver15

The following guide will walk you through the configuration process of the FCI:
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