SQL Database capacity consumption too high !

Hi Azsxdcfvgb​,

I would not expect the SQL Database to continue consuming significant compute for two days simply because the copy activity stopped.

Microsoft’s current SQL Database in Fabric billing documentation says compute scales down after inactivity and is released after about 15 minutes with no workload activity.

So if you are still seeing substantial SQL Usage CUs, I would first confirm what is actually running.

The Capacity Metrics app reports SQL Usage for both user-generated and system-generated SQL queries, modifications and data-processing operations.

I would check:

1. Capacity Metrics -> filter to the SQL Database item and inspect SQL Usage.
2. Drill into the high-CU timepoints and identify which operation/query is still consuming capacity.
3. In the database, check active requests using sys.dm_exec_requests and look for long-running or blocked sessions.
4. Check the Performance Dashboard for expensive queries and activity.
5. Check whether automatic index management or another maintenance/tuning operation is still active.

Microsoft documents SQL Database monitoring specifically for this type of investigation.

The ~3.4 TB size can certainly make index creation, statistics work or other maintenance expensive, but the size alone should not continuously consume compute when the database is genuinely idle.

Regarding the max-vCore setting, your screenshot is also expected.

Microsoft currently ties the vCore limit to maximum storage:

2 vCores -> 512 GB
4 vCores -> 756 GB
32 vCores -> 4 TB

So a ~3.4 TB database cannot be reduced to the smaller vCore limits without first reducing the allocated database size.

I would therefore identify the active SQL Usage before trying to suppress it. If Capacity Metrics shows high SQL Usage but you cannot find any active request or system operation explaining it, I would capture the database ID, timestamps and Capacity Metrics evidence and raise a Fabric support case.

AI-assisted drafting: AI was used to help structure and phrase this response. I reviewed and validated the technical content before posting.