Hi
It looks like you're facing quite an issue with your Azure SQL Serverless database (CTCData) having unexpectedly high CPU billing even when it seems idle. Here’s a breakdown of some potential steps to help troubleshoot and possibly resolve the problem:
Troubleshooting Steps
Monitor Active Connections: It seems you have multiple persistent connections active. These may be contributing to the high CPU usage. You can check and monitor active connections to identify which ones may not be necessary and terminate them if possible.
Investigate Azure Functions: Since you've mentioned that an Azure Function was stopped, make sure that there are no other Azure services or applications still trying to connect to your database that are retaining these persistent connections.
Audit Your Firewall Rules: Since you’ve temporarily disabled public network access, ensure that the firewall rules are appropriately set to restrict unnecessary access and confirm that only required applications can connect to your database.
Check for Scheduled Jobs: Look into whether you have any scheduled jobs or background processes that may be executing at intervals, potentially consuming CPU resources.
Auto-Pause Configuration: Ensure that your configuration for auto-pause is set up correctly and that the minimum and maximum vCores are appropriately defined, which you've already done. If they are set to a low value, it may still be generating costs even in idle periods.
Consider Query Store Statistics: Even if you've disabled the Query Store, ensure that there are no lingering statistics or cached execution plans that are still causing CPU utilization. If possible, clear them and check the impact.
Look at Recent Changes: Since you noted the spike in CPU usage occurred around April 22, review any changes or deployments made around that time that may have inadvertently led to this behavior.
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click Accept Answer
and Yes
for was this answer helpful. And, if you have any further query do let us know.