Why 4 Core is better than 1 Core IaaS Virtual machine with SQL Server in Azure

-> I see not much of a difference in terms of cost when you provision an 1, 2 or 4 Core Azure IaaS Virtual machine with SQL Server Enterprise or Standard edition.

-> I am using Azure pricing calculator to check this.

-> I am checking below IaaS Virtual Machines,

DS1 v2 (1 vCPU(s), 3.5 GB RAM) x 730 Hours
DS2 v2 (2 vCPU(s), 7 GB RAM) x 730 Hours
DS3 v2 (4 vCPU(s), 14 GB RAM) x 730 Hours

-> Checking DS1 v2 (1 vCPU(s), 3.5 GB RAM) x 730 Hours,

Blog92_1

-> Checking DS2 v2 (2 vCPU(s), 7 GB RAM) x 730 Hours
Blog92_2

-> Checking DS3 v2 (4 vCPU(s), 14 GB RAM) x 730 Hours
Blog92_3
-> If you compare SQL Server Enterprise Edition cost for 1 Core, 2 Cores or 4 Cores. It is all same. This is due to the fact that SQL Server license starts with a pack of 4 cores. Even though we use 1 or 2 cores you will be charged for 4 cores. This is applicable for Standard Edition.
-> There is a difference in overall cost between these servers, but to me it is worth to consolidate database Servers to a one (1) – 4 Core Virtual machine rather than provisioning 4 – 1 Core Virtual machines or 2 – 2 Core Virtual machines.
Please let me know your views on comments section.

Thank You,
Vivek Janakiraman

Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.

Leave a Reply