Forum Discussion

Tröttöröö's avatar
Tröttöröö
Frequent Visitor
10 months ago

EventHouse UpTime operation CU increased?

Hi,

Since yesterday there have been a massive increase in CU consumption in EventHouse UpTime operations. No changes have been done the Eventhouse setup. The data volume or quality haven't changed. The Eventhouse is running in Sweden Central.

Any ideas?

 

data engineering

8 Replies

  • Tröttöröö's avatar
    Tröttöröö
    Frequent Visitor
    10 months ago

    We ended up contacting MS support to investigate this further. It took a MS product manager to figure out, what has happened. Increased CPU consumption had triggered the upscaling. Now we know what to optimize. 

    I think it would be nice to have a more accurate documentation about the auto scaling logic.

    • lbendlin's avatar
      lbendlin
      Super User
      9 months ago

      That's one of the reasons why we don't use auto scaling.

    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      9 months ago

      Hi Tröttöröö 

      Thanks for the update and for sharing those details. Glad to hear Microsoft Support helped identify the root cause.

      Could you please confirm if the issue is now fully resolved after applying the optimizations ?

       

  • AntoineW's avatar
    AntoineW
    Super User
    10 months ago

    Hello Tröttöröö,

    Here's some action you can do to check if it's normal : 

     

    • Use the Capacity Metrics App
      → Check detailed CU usage per workload and timepoint.

    • Review Query Logs
      → Look for changes in query patterns or frequency.

    • Check EventHouse Settings
      → Confirm timepoint granularity, retention, and partitioning haven't changed.

    • Open a Microsoft Support Ticket
      → If no internal changes are found, Microsoft can investigate backend operations.

     

    We can definitely see an increase that may need some more investigations ! 

    Hope it can help you,

    Antoine

     

  • lbendlin's avatar
    lbendlin
    Super User
    10 months ago

    We had similar issues and were told to reduce the retention period. Not sure if that is something you can consider.

    • Tröttöröö's avatar
      Tröttöröö
      Frequent Visitor
      10 months ago

      Did this end up reducing CU consumption by auto scaling Eventhouse? If so, how immediate was the effect?

      • lbendlin's avatar
        lbendlin
        Super User
        10 months ago

        Not auto scaling. Within 24 hours, as expected.

  • v-aatheeque's avatar
    v-aatheeque
    Community Support
    10 months ago

    Hi Tröttöröö 

    Just checking in to see if the previous response helped resolve your issue. If not, feel free to share your questions and we’ll be glad to assist.