topic Interactive CU usage when connecting SSMS/VS Code to Fabric Database in SQL database

Interactive CU usage when connecting SSMS/VS Code to Fabric Database

agranaas — Thu, 20 Mar 2025 08:53:49 GMT

Hello!

I'm testing out the database in Fabric and I'm really surprised of the CU usage, it's eating up all available resources.

It's an F2 license.

When I'm connected to the database with SSMS or VS Code, the CU usage goes to 80-100%, and when I close the connection the usage drops to normal levels.

I'm not doing anything (querying, inserting etc.), it's just an active connection to the database in one of the tools (VS Code or SSMS).

Is this expected behavior?

The warehouse does not behave in this way, I see no spikes in CU when connected with VS Code/SSMS all day long.

Re: Interactive CU usage when connecting SSMS/VS Code to Fabric Database

Anonymous — Fri, 21 Mar 2025 02:13:14 GMT

Hi agranaas

Tools like SSMS/VS Code often run background queries (e.g., fetching metadata for IntelliSense, refreshing object explorer, checking session status). These lightweight queries can spike CU usage on low-tier capacities (F2).The F2 SKU has minimal CU allocation (2 CUs). Even minor background activity can max out resources. Higher SKUs (F4+) buffer this better.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Interactive CU usage when connecting SSMS/VS Code to Fabric Database

agranaas — Fri, 21 Mar 2025 09:43:40 GMT

Do you have any idea why the warehouse does not behave in the same way?

Open connections to the warehouse has no impact on CU usage from what I have seen.