The queryinsights schema in Microsoft Fabric is specifically designed for analyzing historical query activity and performance within a warehouse. It contains views like queryinsights.execrequestshistory which store detailed information about completed queries, including the query text, the user who submitted it (loginname), start time, and end time. By querying this view with a T-SQL statement and filtering on the starttime for the last 60 minutes, you can precisely isolate the required queries and user information to investigate the performance degradation.

A. the Microsoft Fabric Capacity Metrics app: This app monitors capacity-level metrics like utilization and throttling, not the specific details of individual historical queries such as the full SQL statement and submitting user.

C. Query activity: While the Query activity page in the Monitoring Hub shows recent queries, the queryinsights schema provides a more powerful and flexible programmatic T-SQL interface for detailed and custom analysis, which is better suited for in-depth performance troubleshooting.

D. the sys.dmexecrequests dynamic management view: This DMV only shows information about requests that are currently executing. It does not provide historical data for queries that have already completed within the last 60 minutes.

1. Query insights in Microsoft Fabric data warehousing: Microsoft Learn. "Query insights is a feature of Microsoft Fabric data warehousing that provides a holistic view of the historical query activity in the Warehouse... You can use T-SQL to query the Query insights views to find details on historical query executions." This document details the purpose and usage of views like queryinsights.execrequestshistory.

Source: Microsoft Learn

"Query insights in Microsoft Fabric data warehousing"

Section: "Query insights views".

2. Monitoring connections

sessions

and requests using DMVs: Microsoft Learn. "For information on queries that have completed

failed

or been canceled

see queryinsights.execrequestshistory... sys.dmexecrequests shows all requests currently executing in the service." This explicitly distinguishes the use case for sys.dmexecrequests (current) from queryinsights (historical).

Source: Microsoft Learn

"Monitor connections

sessions

and requests using DMVs in Microsoft Fabric"

Section: "Monitor requests".

3. Microsoft Fabric Capacity Metrics: Microsoft Learn. This documentation describes the metrics app's purpose for monitoring capacity usage

performance

and identifying bottlenecks at the capacity level

not for detailed query-level analysis.

Source: Microsoft Learn

"Microsoft Fabric Capacity Metrics"

Section: "Overview".