Monitoring data warehouse activity
As of writing this in January 2024, the data warehouse experience does not appear in Fabric's Monitoring hub. Instead, administrators will rely on Dynamic Management Views (DMVs) to gain insight into warehouse and SQL endpoint activity. Combined, the DMVs provide a view into server connections (sys.dm_exec_connections), sessions (sys.dm_exec_sessions), and active queries (sys.dm_exec_requests).
Looking at the data in these can answer a few key questions:
- Who is connected to the warehouse and from where?
- What queries are executing right now?
- Who is executing queries right now?
- How long have queries been executing?
Using a script available in the Fabric toolbox (https://aka.ms/FabricToolbox), these DMVs can be joined together to provide a look at all the current database activity.
Figure 7.13 – An example output from the Fabric SQL DMVs
DMVs provide valuable information but only...
