queryinsights.frequently_run_queries (Transact-SQL)
Applies to: SQL analytics endpoint and Warehouse in Microsoft Fabric
The queryinsights.frequently_run_queries
in Microsoft Fabric provides information about frequently run queries in Fabric Data Warehousing.
Column name | Data type | Description |
---|---|---|
last_run_start_time | datetime2 | Time of the most recent query execution. |
last_run_command | varchar(8000) | Text of the last query execution. |
number_of_runs | int | Total number of times the query was executed. |
avg_total_elapsed_time_ms | int | Average query execution time (ms) across all runs. |
last_run_total_elapsed_time_ms | int | Time taken by the last execution (ms). |
last_dist_statement_id | uniqueidentifier | ID linking the query to queryinsights.exec_requests_history . |
last_run_session_id | smallint | User session ID for the last execution. |
min_run_total_elapsed_time_ms | int | Shortest query execution time (ms). |
max_run_total_elapsed_time_ms | int | Longest query execution time (ms). |
number_of_successful_runs | int | Number of successful query executions. |
number_of_failed_runs | int | Number of failed query executions. |
number_of_cancelled_runs | int | Number of canceled query executions. |
Permissions
You should have access to a SQL analytics endpoint or Warehouse within a Premium capacity workspace with Contributor or above permissions.
Related content
- Monitoring connections, sessions, and requests using DMVs in Microsoft Fabric
- queryinsights.long_running_queries (Transact-SQL)
- queryinsights.exec_requests_history (Transact-SQL)
Next step
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for