AzureSQLQueryStoreWaitStatistics

Query Store Wait Statistics for Azure SQL Database.

Table attributes

Attribute Value
Resource types microsoft.sql/servers
Categories Workloads
Solutions LogManagement
Basic log No
Ingestion-time DCR support No
Lake-only ingestion No
Sample Queries -

Columns

Column Type Description
_BilledSize real The record size in bytes
Category string The category of the log.
CountExecutions long Number of executions.
DatabaseName string Database name.
ElasticPoolName string Elastic pool name if applicable.
ExecType int Execution type.
IntervalEndTime long Interval end time.
IntervalStartTime long Interval start time.
_IsBillable string Specifies whether ingesting the data is billable. When _IsBillable is false ingestion isn't billed to your Azure account
IsParameterizable string Whether the query is parameterizable.
IsPrimary long Is primary replica.
Location string Azure region location.
MaxQueryWaitTimeMs real Maximum query wait time in milliseconds.
OperationName string The operation name.
PlanId long Plan ID.
QueryHash string Query hash.
QueryId long Query ID.
QueryParamType int Query parameter type.
QueryPlanHash string Query plan hash.
ReplicaGroupId long Replica group ID.
_ResourceId string A unique identifier for the resource that the record is associated with
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
StatementKeyHash string Statement key hash.
StatementSqlHandle string Statement SQL handle.
StatementType string Statement type.
_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.
TotalQueryWaitTimeMs real Total query wait time in milliseconds.
Type string The name of the table
WaitCategory string Wait category.
  • Last updated on