SQL AlwaysOn
Posted by Mikhail Rodionov on March 27, 2018

wp-image-7668

I guess once you will read through this article you will also notice how this technology is shaped out of familiar building blocks, but what I also hope for is that you will get a grasp of what is AlwaysOn, and get a basic understanding of how it works. I will fully cover installation and configuration of SQL Server AlwaysOn environment (using new and shiny SQL Server 2017) in my next article while focusing on technology overview here.

(more…)

Cost and License considerations between Always On Availability Groups and Always On Basic Availability Groups
Posted by Shashank Singh on October 17, 2017

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…)