Forum Discussion

joaomacp's avatar
joaomacp
New Member
7 months ago
Solved

Excessive CU usage in Fabric IQ

I’m running a tiny PoC with Fabric IQ and hitting a bottleneck with capacity consumption. The setup is super simple:   Capacity: F4 Data: 2 tables from Lakehouse. A "Sale" fact table with 2k rows...
  • arabalca's avatar
    7 months ago

    Hi joaomacp ,

    The same thing has happened to me. We are currently testing and, while I understand that optimizations will improve over time, I think it is important to acknowledge something: AI workloads like this are not designed to run efficiently on small capacities such as F2 or F4.

    In my opinion, Fabric IQ brings a lot of value and is something that you almost need to have in your roadmap. However, we also need to be aware that this value comes with a cost. This is where a key aspect comes into play: DataOps.

    We are moving into more complex scenarios (real-time, agents, graphs, etc.), and this means it is no longer just about building solutions. We need to start thinking seriously about:

    • The ROI of each use case
    • How to optimize capacity consumption
    • Which workloads truly justify this level of investment

    As an additional recommendation, I believe it will be key to:

    • Properly separate environments (dev/test/prod) to avoid unnecessary capacity consumption
    • Monitor usage from the beginning
    • Prioritize use cases with real business impact

    Thanks for sharing your experience. If you notice any updates or improvements, it would be great if you could share them