Microsoft SQL Server Failover Cluster Instance and Basic Availability Group features comparison
Posted by Dima Yaprincev on November 9, 2017
5/5 (2)

Introduction

Microsoft SQL Server 2016 has a pretty decent feature set to achieve cost-effective high availability for your environment and build a reliable disaster recovery solution. Basic Availability Groups (BAGs) and Failover Cluster Instances (FCI) are included in SQL Server 2016 Standard Edition and serve to implement high redundancy level for business-critical databases. In this article, I would like to discuss some differences between these solutions and open the curtain on how it can be done with Software-Defined Storage like Storage Spaces Direct (S2D) and StarWind Virtual SAN (StarWind VSAN).

Failover Cluster Instance versus Basic Availability Group image

(more…)

Please rate this

Cost and License considerations between Always On Availability Groups and Always On Basic Availability Groups
Posted by Shashank Singh on October 17, 2017
5/5 (2)

Windows Server edition considerations

With Windows Server 2012 and above, Standard Edition now has full support for clustering, not just simple 2-node active/passive clusters, but fully configured clustering support.  Before Windows Server 2012, only Windows Server Enterprise Edition could support Windows Server Failover Clustering (WSFC). Starting from Windows Server 2012, clustering got a huge licensing cost reduction.

The cost of Windows Server 2012 Standard is almost the same as that of Windows Server 2008 R2 Standard, but Windows Server 2012 Datacenter Edition has almost 26% price increase. There is no difference throughout feature support between Windows Server 2012 Standard and Datacenter edition; the major difference is that Standard only supports hosting of 2 virtual machines (by default), while in Datacenter this is unlimited. You can host more than 2 VMs on Standard, but that will imply an extra cost.

BAG vs AG

(more…)

Please rate this