SynapseSqlPoolWaits

Information about the wait states encountered during execution of a SQL request/query in an Azure Synapse dedicated SQL pool, including locks and waits on transmission queues.

Table attributes

Attribute Value
Resource types microsoft.synapse/workspaces
Categories Azure Resources
Solutions LogManagement
Basic log Yes
Ingestion-time transformation Yes
Sample Queries -

Columns

Column Type Description
_BilledSize real The record size in bytes
Category string The category of the log.
_IsBillable string Specifies whether ingesting the data is billable. When _IsBillable is false ingestion isn't billed to your Azure account
LockType string The lock type of the SQL instance.
LogicalServerName string The logical server name of the SQL DW.
OperationName string The operation associated with log record.
Priority int The priority of the waits.
RequestId string The request ID of the waits.
ResourceGroup string The azure resourceGroup of the SQL DW.
_ResourceId string A unique identifier for the resource that the record is associated with
SessionId string The session ID of the SQL request.
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
State string The State of the waits.
_SubscriptionId string A unique identifier for the subscription that the record is associated with
TenantId string The Log Analytics workspace ID
TimeGenerated datetime The timestamp (UTC) of when the log was generated.
Type string The name of the table