Forum Discussion
CU Utilization Help Needed
- 1 year ago
Thank you for these great tips. I actually found the culprit - The rollout of Copilot for Fabric to all the smaller capacities. When it rolls out to you, it will be enabled by default.
Microsoft documentation provides the following "warning" - "Enabling Copilot in Fabric for your entire tenant without adequate planning and preparation can lead to higher Fabric capacity utilization and other potential risks. Consider enabling Copilot in Fabric for specific security groups and workspaces only after you take the appropriate steps to prepare"
If you are running a small capacity, I recommend that you check for the rollout to your tenant and disable until you have time to test the impact.
Hi mheggie ,
Thank you for reaching out to the Microsoft Fabric Community.
The spike likely relates to internal system activities triggered by queries against telemetry views like queryinsights and INFORMATION_SCHEMA. These can sometimes cause expensive metadata scans, especially if historical or broad queries are executed.
Here are recommended steps to follow to resolve the issue:
-
Query sys.dm_exec_requests for any long-running or system-triggered processes:
SELECT session_id, command, status, cpu_time, total_elapsed_time
FROM sys.dm_exec_requests
WHERE session_id > 50
ORDER BY total_elapsed_time DESC;
-
When using queryinsights, always filter on recent timeframes (e.g., last 1 day) to avoid scanning full telemetry.
-
After pausing and resuming capacity, some background rehydration tasks may consume CUs temporarily. Allow a 30–45 minute window for stabilization after resumption.
For more detailed information, you may find the following resources helpful:
What is the Microsoft Fabric Capacity Metrics app? - Microsoft Fabric | Microsoft Learn
Query Insights - Microsoft Fabric | Microsoft Learn
Pause and resume your capacity - Microsoft Fabric | Microsoft Learn
I hope this will resolve your issue, if you need any further assistance, feel free to reach out.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thankyou.