Forum Discussion

jbauer22's avatar
jbauer22
Icon for Advocate II rankAdvocate II
1 year ago
Solved

Fabric Capacity Metrics App - User CU Analysis

Is there a way to look at CU usage by User and then Operation for the last 14 days?  I would like to determine what user(s) are consuming the most CUs and then analyze what operations they are perfor...
  • v-ssriganesh's avatar
    1 year ago

    Hi jbauer22,

    Thank you for reaching out to the community forum with your query.

    The Fabric Capacity Metrics App itself doesn't provide a direct way to view CU usage by User and then Operation for the last 14 days. The Timepoint view is indeed limited in its scope. However, Azure Monitor Logs can be utilized to achieve this. This tool enables querying detailed resource usage information. By writing Kusto Query Language (KQL) queries, you can: Filter for the last 14 days, Group by User and Operation, Calculate the total CU consumption, and visualize the results using log analytics features.

    For more detailed guidance on how to use Azure Monitor Logs and write KQL queries, you can refer to the official Microsoft documentation links below:
    https://learn.microsoft.com/en-us/azure/azure-monitor/logs/log-query-overview

    https://learn.microsoft.com/en-us/azure/azure-monitor/logs/get-started-queries

    If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
    Thank you.