I have frequently come across a situation where, clients are usually confused about the selection of MS SQL edition and whether they should go on-premise or on cloud. And given the fact that there are other IaaS players too, selection of hosting a SQL server on cloud becomes even more difficult.
Editions of 2016 MS SQL
Microsoft recently launched 2016 MS SQL editions. They are available in 4 flavors: Express, Standard, Enterprise and Developer
Here is the brief summary of what these editions are meant for :
Although there is a lot of information available on Microsoft’s website, I have filtered out some of the most important features of different 2016 editions which should be considered before finalizing which edition is right for you.
* Basic HA – restricted to 2 node single database failover, and non readable secondary db. Basic HA ensure data availability so your data is not lost with basic HA and a fast two nodes non-readable synchronous replica.
** Advanced HA – Always On- availability groups, multi-database failover with readable secondaries.
There are 4 costs associated in an op-premise set up.
- Infra cost
- Licenses cost
I would like to focus only on licensing cost. There are 2 types of licenses available for SQL Standard editions
- Server + CAL license: Cost of MS SQL server is $ 931 and $ 209 per Client access license (CAL) which is either used based or device based.
- Core based license : $ 3,717 per core, in 2 core packs. There is no restriction on the number of users or devices which can access the server in this type of license.
On Cloud deployment:
The benefit of spinning up SQL server on cloud is it’s fast, easy and you also have an option of getting a fully managed SQL instances.
Comparison of costs on Azure, AWS and Softlayer
Below tables shows the configurations which were considered.
|For AWS and IBM SoftLayer|
The graph shows clearly that SoftLayer is the cheapest when compared to both AWS and Azure. Following are the added advantages with IBM SoftLayer :
- Data download limit of 250 GB with virtual instances and 500 GB with Bare Metal instances
- There is no inter DC charges
- The instances are not bundled, so you have the flexibility of increasing or decreasing cores, RAM and HDD independently which is not in the case of Azure
Comparing the cost of on-cloud vs on-premise is little tricky. You need to take the following things in to account :
- When is your server hardware refresh due: This is important because assuming you have recently invested in the hardware and the next refresh is due only after 3 years, then you will incur only the license cost of MS SQL. In this case, most of the times, going for an on-premise will make more sense.
- No. of users in the organization: Assuming you only have 20 -25 users and there is a lot of uncertainty about the increase or decrease of the no. of users, then in this case, most of the times, on-cloud will make sense. You just have to purchase the server license and then you can take CALs from your cloud service provider which comes in a minimal monthly cost.
In case you want to need to know more about the implementation and pricing on SoftLayer and want to do a TCO for your implementation then, you can reach out to me on this link or drop a comment here.