You have a Fabric workspace that contains a warehouse named Warehouse1. While monitoring Warehouse1, you discover that query performance has degraded during the last 60 minutes. You need to isolate…

The Microsoft Fabric Capacity Metrics app provides high-level capacity usage metrics and doesn't offer detailed query statements or usernames.

Views from the queryinsights schema are specifically designed for historical analysis of query performance in Fabric, which would be more comprehensive for 'all queries that were run'.

The sys.dm_exec_requests dynamic management view provides information about currently executing requests and recently completed ones in a SQL Warehouse, including the query text and the login name of the user who submitted the query. This view is suitable for immediate diagnosis of performance issues by examining recent and active workloads.

The sys.dm_exec_query_stats dynamic management view provides aggregated performance statistics for query plans in the cache, not individual query statements or usernames for recent executions.