What is difference between VCore of SQL Database and Vcore of General Purpose

Blanka Oljelund 20 Reputation points
2024-09-06T11:16:44.18+00:00

Hi!

I am doing this training: Prepare to maintain SQL databases on Azure

And it says the below which really confuses me.

It makes a difference between VCore of SQL Database and Vcores of General Purpose, and in the Standard Edition it does not include a VCore of SQL Database - But does not a SQL Database always come with a VCore? So why do they add it separately to the Enterprise Edition.. I don't understand, please help

  • For each core of Enterprise Edition with Active Software Assurance, you're eligible for one vCore of SQL Database or SQL Managed Instance Business Critical, and eight vCores of General Purpose.
  • For each core of Standard Edition with Active Software Assurance, you're eligible for one vCore of General Purpose.
SQL Server Other
0 comments No comments
{count} votes

Accepted answer
  1. Bruce (SqlWork.com) 77,686 Reputation points Volunteer Moderator
    2024-09-06T15:45:01.3433333+00:00

    Vcore represents the size, power and features (say failover speed) of the virtual machine hosting your sql database.

    https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-sql-database-vcore?view=azuresql

    when you create a azure sql database, you will pick the Vcore type and number of Vcores for that database.


1 additional answer

Sort by: Most helpful
  1. Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
    2024-09-06T14:18:55.0366667+00:00

    The way I read it is that the vCores are benefits. There are no technical connections here. It could just as well say "for each core of Enterprise Edition, you are entitled to a free night at the Ramadama Hotel". (Which of course would be a very funny benefit, but that's another story.)

    On the other hand, the cores (without the v in front) are stuff that you pay for.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.