QuestionQ63

VerifiedMaintain a data analytics solution

You have a Fabric tenant that contains a warehouse.

A user discovers that a report that usually takes two minutes to render has been running for 45 minutes and has still not rendered.

You need to identify what is preventing the report query from completing.

Which dynamic management view (DMV) should you use?

Explanation

Fabric Warehouse's monitoring guidance points to the standard SQL Server-compatible DMV sys.dm_exec_requests to inspect currently executing requests, their status, wait types, and blocking information, which is what you need to find why a query has been stuck for 45 minutes. sys.dm_pdw_exec_requests is specific to Azure Synapse Analytics dedicated SQL pools' MPP control/compute node architecture and is not the DMV surfaced for Fabric Warehouse monitoring.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!