queryinsights.exec_requests_history (Transact-SQL)
Applies to: SQL analytics endpoint and Warehouse in Microsoft Fabric
The queryinsights.exec_requests_history
in Microsoft Fabric provides information about each complete SQL request.
Column name | Data type | Description |
---|---|---|
distributed_statement_id | uniqueid | Unique ID for each query. |
start_time | datetime2 | Time when the query started running. |
command | varchar(8000) | Complete text of the executed query. |
login_name | varchar(128) | Name of the user or system that sent the query. |
row_count | bigint | Number of rows retrieved by the query. |
total_elapsed_time_ms | int | Total time (ms) taken by the query to finish. |
status | varchar(30) | Query status (Succeeded, Failed, or Canceled). |
session_id | smallint | ID linking the query to a specific user session. |
connection_id | uniqueid (nullable) | Identification number for the query's connection. |
batch_id | uniqueid (nullable) | ID for grouped queries (if applicable). |
root_batch_id | uniqueid (nullable) | ID for the main group of queries (if nested). |
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.frequently_run_queries (Transact-SQL)
Next step
Tilbakemeldinger
https://aka.ms/ContentUserFeedback.
Kommer snart: Gjennom 2024 faser vi ut GitHub Issues som tilbakemeldingsmekanisme for innhold, og erstatter det med et nytt system for tilbakemeldinger. Hvis du vil ha mer informasjon, kan du se:Send inn og vis tilbakemelding for