SynapseDXQuery
Azure data explorer synpase query execution summary. Logs include DatabaseName, State, Duration that can be used for monitoring the queries which were invoked on the cluster
Categories
- Azure Resources
Solutions
- LogManagement
Resource types
- Synapse Workspaces
Columns
| Column | Type | Description |
|---|---|---|
| ApplicationName | string | The name of the application that invoked the query |
| CacheDiskHits | long | Disk cache hits |
| CacheDiskMisses | long | Disk cache misses |
| CacheMemoryHits | long | Memory cache hits |
| CacheMemoryMisses | long | Memory cache misses |
| CacheShardsBypassBytes | long | Shards cache bypass bytes |
| CacheShardsColdHits | long | Shards cold cache hits |
| CacheShardsColdMisses | long | Shards cold cache misses |
| CacheShardsHotHits | long | Shards hot cache hits |
| CacheShardsHotMisses | long | Shards hot cache misses |
| Category | string | The log category for these events will be 'Query' |
| CorrelationId | string | The client request ID |
| DatabaseName | string | The name of the database the command ran on |
| Duration | string | Query duration as a string like '00:00:00.0156250' |
| ExtentsMaxDataScannedTime | datetime | Maximum data scan time |
| ExtentsMinDataScannedTime | datetime | Minimum data scan time |
| FailureReason | string | The reason for the failure |
| LastUpdatedOn | datetime | The time (UTC) this command ended |
| MemoryPeak | long | Memory peak |
| Principal | string | The principal that invoked the query like 'aaduser=USER_ID;TENANT' |
| _ResourceId | string | A unique identifier for the resource that the record is associated with |
| RootActivityId | string | The root activity ID |
| ScannedExtentsCount | long | Scanned extents count |
| ScannedRowsCount | long | Scanned rows count |
| SourceSystem | string | |
| StartedOn | datetime | The time (UTC) this command started |
| State | string | The state the command ended with like 'Completed' |
| _SubscriptionId | string | A unique identifier for the subscription that the record is associated with |
| TableCount | int | Table count |
| TablesStatistics | dynamic | Tables statistics |
| TenantId | string | |
| Text | string | Text of the invoked query |
| TimeGenerated | datetime | The time (UTC) this event was generated |
| TotalCPU | string | Total CPU runtime across cluster nodes |
| TotalExtentsCount | long | Total extents count |
| TotalRowsCount | long | Total rows count |
| Type | string | The name of the table |
| User | string | User that invoked the query |
| WorkloadGroup | string | Workload are a means of resource governance for incoming requests to the cluster |