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
Table attributes
Attribute
Value
Resource types
microsoft.synapse/workspaces
Categories
Azure Resources
Solutions
LogManagement
Basic log
No
Ingestion-time transformation
No
Sample Queries
-
Columns
Column
Type
Description
ApplicationName
string
The name of the application that invoked the query
_BilledSize
real
The record size in bytes
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
_IsBillable
string
Specifies whether ingesting the data is billable. When _IsBillable is false ingestion isn't billed to your Azure account
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
The type of agent the event was collected by. For example, OpsManager for Windows agent, either direct connect or Operations Manager, Linux for all Linux agents, or Azure for Azure Diagnostics
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
The Log Analytics workspace ID
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