Azure SQL Database
An Azure relational database service.
5,176 questions
Why does one Stored Procedure with a 5.3s Web App response time result in 13.02 hours of CPU Time (metric)?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 24%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Tyler
1
Reputation point
I have a web app where I ran a stored procedure on button click event. Upon reviewing the metrics, I see the stored procedure resulted in a 5.3 second response time, but a 13.02 hour CPU Time (Sum). Does that seem reasonable? Thanks!
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 59%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SnehaAgrawal-MSFT 18,366 Reputation points2021-05-10T13:37:58.167+00:00 Thanks for asking question! Could you please elaborate your query to help you better on this. If you are facing any performance issues with your web app?
Further adding some points here:Response Time is the time taken for the app to serve requests, in seconds.
CPU time is the amount of CPU consumed by the app, in seconds, because one of their quotas is defined in CPU minutes used by the app. Its calculated over one application uses. Further CPU time is useful for apps hosted in Free or Shared plans.
You may refer to Monitor apps in Azure App Service for details.
Let us know.
Sign in to comment