Elastic Pool and Database - High usage CPU and DTU

Question

Hello,

I am facing some problems on Azure SQL Database.

We recently got an High Usage CPU and also DTU (reaching 100% ) on our Azure SQL Database, we are using Elastic Pool and we increase from 400 DTU to 1200 DTU.

However the DTU from Azure SQL Server keept 100% usage.

Do you know how to increase it?

Answer 1

Based on my experience with this issue, my recommendation is to look into the Performance Overview section and the Query Performance Insight sections on Azure Portal, identify queries with high DTU usage and do query optimization. You can scale up to tiers and find some relief but at the end of the month Management at your organization may be alarmed by the amount due on the Azure Invoice.

Scaling up DTU databases may take quite a while depending on the size of the database and other factors. Moving databases with high CPU consumption to elastic pools of vCore model can help scale up only the number of vCores and have less impact on client applications, while you are able to optimize the queries.

Usually I found the spike on CPU usage happens during the execution of specific processes at specific hours of the day. Identify those processes and optimize queries and programming objects (stored procedures, etc.) related with those processes.

Sometimes you just need to create some missing indexes or you just need to create a maintenance plan to keep indexes and statistics in good shape.