SQL Server Licensing & Clustering for Availability Groups

by ToC   Last Updated January 16, 2018 14:06 PM

For SQL Server 2014, reading this MSDN link and Microsoft PDF file about licensing, created a couple of questions.

  • For Availability Groups do we need WSFC or FCI?
  • How are WSFC and FCI different?
  • If we only need 2 AG nodes, could SQL Server Standard Edition work?

Answers 1

  • In SQL Server 2012 and 2014, the Availability Groups feature requires an underlying WSFC (see this post for info on newer versions). You can use FCIs in combination, but it is not required (and in fact often overkill, depending on what you are trying to accomplish and whether you have underlying redundancy as well).
  • WSFC is the underlying Windows Server Failover Cluster. FCI is just the terminology for a single SQL Server failover cluster instance. An FCI depends on a WSFC, and can use 1-n nodes of the WSFC to provide failover scenarios for the clustered instance. Some good background here from Allan Hirt. Basically, an FCI protects a single, entire instance of SQL Server (when a failover happens, the entire instance moves to the next preferred owner in the WSFC). A WSFC protects an instance of Windows, and any SQL Server instances on it. An Availability Group uses the underlying WSFC to protect a group of databases.
  • In 2012 / 2014, Standard Edition does not support Availability Groups in any shape or form - Enterprise Edition is required. In SQL Server 2016 and above, there is "Basic Availability Group" for Standard Edition - 2 nodes only, 1 database per group, no formal listener support, no read-only secondaries, etc. Official Documentation...
Aaron Bertrand
Aaron Bertrand
July 23, 2015 15:33 PM

Related Questions

SQL Server error 19456 when adding the listener

Updated December 05, 2018 19:06 PM

SQL Server 2014 SP2 upgrade on Alwayson + FCI

Updated August 17, 2017 08:06 AM

Unable to failover through AG Wizard in sql server 2014

Updated February 03, 2018 07:06 AM

SQL Server 2014 - Replica Server not available

Updated August 11, 2015 17:02 PM