What is CoreUtilizationCoefficient w.r.t the Export Capacity of the ADX.

Srivatsan kothandraman 41 Reputation points
2021-01-08T15:37:54.727+00:00

Hi All,

I am updating the value of CoreUtilizationCoefficient to increase the Export Capacity of ADX. As I increase this value the number capacity of Export Increases. I went through this documentation that explains what CoreUtilizationCoefficient capacitypolicy

I wanted to know what are the drawbacks of increasing the count. Does it affect the performance of the Overall ADX or does it increase the cost.

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
502 questions
Accepted answer
  1. KranthiPakala-MSFT 46,437 Reputation points Microsoft Employee
    2021-01-13T00:24:25.617+00:00

    Hi @Srivatsan kothandraman ,

    Sorry for the delay in response.

    Altering the capacity policy could result with more physical resources allocated for the virtual resources.

    • As physical resources are shared between commands & queries – this could increase contention.

    Specifically in the case of export – it could increase the likelihood of the target resource (SQL server / blob storage / ADLS) hitting its limits

    If you choose to alter the policy, you should closely monitor the impact on the cluster's CPU usage (e.g. via metrics in the portal) and on success rate of this and other workloads running against the cluster (e.g. using ".show commands-and-queries")

    An alternative, usually safer/recommended, approach for increasing the capacity is scaling out/up.

    Hope this info helps.

    ----------

    Thank you
    Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest