azure cpu percentage vs sql instance cpu means

Question

azure cpu percentage vs sql instance cpu means

k shaz 36

i have azure sql server what does CPU Percentage (Max) vs SQL Instance CPU Percentage (Max) disparity means for planning and sizing.

SSingh-MSFT 16,371 Reputation points Moderator

2023-08-31T03:39:51.24+00:00

Hi
k shaz •,

Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.
Brophy, James 0 Reputation points

2023-11-21T12:51:51.03+00:00

With regard to Compute utilization of an Azure SQL Database on an Azure (Logical) SQL Server, I assume SQL instance CPU percent (Max) refers to the percentage of CPU that the Database under review is using compared to other Azure SQL Databases on the Azure (Logical) SQL Server. Whereas, CPU percent (Max) refers to the percentage of CPU resource that the Database under review has been allocated under Compute + storage.
kamel BENYAHIA 56 Reputation points

2023-11-22T12:21:22.8166667+00:00

Hello ,

I have the same question about the difference between cpu_percent and sql_instance_cpu_percent, which metric reflects the real CPU consumption?

I am on Azure SQL database . the graphs below are very different .

Accepted answer

0 additional answers

Your answer

SSingh-MSFT 16,371 Reputation points Moderator

2023-08-31T03:39:51.24+00:00

Hi
k shaz •,

Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.
Brophy, James 0 Reputation points

2023-11-21T12:51:51.03+00:00

With regard to Compute utilization of an Azure SQL Database on an Azure (Logical) SQL Server, I assume SQL instance CPU percent (Max) refers to the percentage of CPU that the Database under review is using compared to other Azure SQL Databases on the Azure (Logical) SQL Server. Whereas, CPU percent (Max) refers to the percentage of CPU resource that the Database under review has been allocated under Compute + storage.
kamel BENYAHIA 56 Reputation points

2023-11-22T12:21:22.8166667+00:00

Hello ,

I have the same question about the difference between cpu_percent and sql_instance_cpu_percent, which metric reflects the real CPU consumption?

I am on Azure SQL database . the graphs below are very different .

Answer 1

Alberto Morillo 34,671 MVP Volunteer Moderator

If you are thinking on hardware sizing and planning migration, and you want to find how comparable are CPU resources on an Azure SQL VM (IaaS) compared to CPU resources on an Azure SQL Managed Instance, sure you can find some guidelines and information on this support article.

But, if you want to find how comparable are CPU resources on an Azure SQL Database (PaaS) compared to CPU resources on an Azure SQL Managed Instance, then they may not be directly comparable, because they have different underlying architectures and resource allocation mechanisms. You may have to run the same workload on both environments and compare how many CPUs you may need to get the expected/target performance you need.

GREGOVIC Andrew (Consulting For Edenred) 15 Reputation points

2024-02-14T07:54:05.8666667+00:00

I don't see how this answer relates to the original question. Here's another try - what does 52.75% vs 60.46% specifically mean at this point in time?
Mehdi Jafari 0 Reputation points

2024-11-17T12:39:53.8633333+00:00

it gets mad how lazy Microsoft support is in case of providing answers. I just want to know the difference between the two in the same service. they just to copy paste something unrelated for the sake of putting something there

Share via

azure cpu percentage vs sql instance cpu means

Hello ,

0 additional answers

Your answer