Forum Discussion

AnHell's avatar
AnHell
Helper I
10 months ago
Solved

Real Time Detailed Activity Monitor

Hello community,   After many years working with SQL Server on premise, I have just upgraded to Fabric, and to begin with, I am missing something important.   At the company where I work, there a...
  • tayloramy's avatar
    10 months ago

    Hi AnHell

     

    The Capacity Metrics app is the best way to find this info. For existing items, it has about a 15 or so minute delay in data, and new items only appear once the semantic model refreshes. 

     

    In Capacity Metrics, you can drill through to a specific 30 second timepoint and see exactly what was comsuming capacity at that time: Understand the metrics app timepoint page - Microsoft Fabric | Microsoft Learn

     

    You can also query DMVs in lakehouses and warehouses SQL endpoints to see active sessions at the database level. 

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.