Share via

Sql server Metrics : is 100% CPU percentage is a blocker for all DB operations?

Manoj Mathe 20 Reputation points Microsoft Employee
2024-05-27T01:27:28.3866667+00:00

HI All

We have observed a case in our database where the CPU perncetage is 100% for quite some time but my application are still able to hit & operate over DB, is 100% CPU usage isnt a blocker for DB operations ??

I see 2 CPU metrics 1) CPU Percentage(MAX) 2) SQ:L instance CPU percentage(MAX) what is the difference btwn them ? in my case CPU percentage is 100% but SQLInstance CPU percentage is 50% only

User's image

please share me insights on this metrics and how to translate this.

Thanks in Advance,

Manoj.

Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,444 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,164 questions
Accepted answer
  1. Oury Ba-MSFT 17,556 Reputation points Microsoft Employee
    2024-05-30T03:29:27.8133333+00:00

    Manoj Mathe

    100% CPU utilization doesn't make queries fail directly. It makes them run slower. If there is a timeout set on the client, then the slowness may cause the timeout to be hit, which fails the query.

    For details on the two CPU metrics, see https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-logical-server?view=azuresql#resource-consumption-by-user-workloads-and-internal-processes

    Regards,

    Oury

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sushama Agrawal 1 Reputation point
    2024-05-27T05:50:21.6433333+00:00

    "CPU Percentage (MAX)" measures the total CPU usage of the entire system, while "SQL Instance CPU Percentage (MAX)" isolates the CPU usage to the SQL Server instance alone.

    • CPU Percentage (MAX): If this value is high, it could be due to SQL Server, the web server, background services, or any combination of these.
      • Use Case: This metric is useful for understanding the general load on the system and determining if there is a need to upgrade hardware or optimize other running services to ensure smooth operation
    • SQL Instance CPU Percentage (MAX): If this value is high, it specifically indicates that SQL Server is using a lot of CPU resources, guiding you to focus on SQL Server for performance tuning.
      • Use Case: This metric is particularly useful for database administrators (DBAs) to monitor and troubleshoot SQL Server performance issues without the noise from other applications.
    0 comments