Forum Discussion
Mirroring SQL Endpoint Capacity Usage
Hi v-achippa and JVDA98
I just had a call with Microsoft Support and was informed that this is indeed a result of the new metering system. SQL usage is now aggregated at the workspace level rather than being attributed to individual users, which explains the behavior we are seeing.Kind regards,
Nichael
Hi FabricEnjoyer,
Thank you for reaching out to Microsoft Fabric Community.
The increase in sql endpoint query CU is most likely related to the recent fabric metering change for warehouse or sql endpoint workloads. This can report higher CU usage, especially for frequent or short running queries, this does not indicate an issue with the open mirroring setup.
The generic User value is a separate issue. Please verify that Show user data in the Microsoft Fabric Capacity Metrics app and reports is enabled under the Fabric Admin portal --> Tenant settings --> Audit and usage.
If that setting is already enabled and individual users are still being shown only as User, please raise a Microsoft support ticket so that the team can check the user attribution behaviour.
Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn
Thanks and regards,
Anjan Kumar Chippa
Hi v-achippa
Thank you for your response.
I had a look at the settings, and it appears that everything is enabled as expected.
I will log a support ticket with Microsoft to investigate this further.
Thank you.
Just checking in if you had any feedback so far on this. We are having the same issue on different tenants regarding the "user".
Regarding the exploded CU-usage, I am trying a bit with Custom SQL Pools to reduce the load, but this is not working for each increase we've seen.
Succesfully reduced the CUs needed to refresh Power BI Semantic Models, but queries / paginated reports still stay inflated since 11/08.
