Blog Post

Azure Database Support Blog
5 MIN READ

Calculating CPU percentage for active queries

SamGarth's avatar
SamGarth
Icon for Microsoft rankMicrosoft
Sep 04, 2023
The ability to measure CPU percentage for each active query can be useful to identify an issue, or set up alerting for abnormal usage.   Trying to identify the top queries consuming high CPU with...
Updated Sep 04, 2023
Version 1.0
azure
azure sql
azure sql database
azure sql managed instance
Azure SQL Performance
CPU
CPU Utilization
sql server
henriqueAcevedo's avatar
henriqueAcevedo
Copper Contributor
Oct 04, 2023

Hi Sam! I noticed that when running the script, I'm getting the error:

"Divide by zero error encountered."

What I did was modify the part "100.0 / (r.total_elapsed_time * @CPU_Count) * r.cpu_time," and added the division by 100.0 at the end:

(r.total_elapsed_time * @CPU_Count) * r.cpu_time / 100.0

With this change, it ran successfully and was very helpful! Excellent script!!