Forum Discussion
rdlhrvy
Helper I
Helper IFabric Capacity Metrics (Operation - Query)
I am investigating the high CU consumptions against Capacity. Is there anyway to find out what query has been executed against the model or what interaction they are doing to the report? See picture ...
AndyDDC
Most Valuable Professional
Most Valuable ProfessionalI don't know if there's anything directly in the fabric capacity metric apps that could help, however you could use profiler in a tool like sql server management Studio to connect to the workspace endpoint and capture analysis services events to pinpoint any issues with specific queries in the semantic model
rdlhrvyHelper I
Helper II only monitor it with DAX Studio but no luck identifying what is already executed from that timepoint if my Dax Studio is not running to capture the queries executed. I wish there's a way in fabric capacity to identify what query executed. It's easier to investigate why that query takes so long to execute