AzureSQLQueryStoreRuntimeStatistics

Query Store Runtime 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 Log category.
count_executions long Count of executions.
cpu_time long CPU time in microseconds.
DatabaseName string Database name.
dop long Degree of parallelism.
duration long Duration in microseconds.
ElasticPoolName string Elastic pool name if applicable.
execution_type long Execution type.
interval_end_time long Interval end time.
interval_start_time long Interval start time.
is_primary long Is primary replica.
_IsBillable string Specifies whether ingesting the data is billable. When _IsBillable is false ingestion isn't billed to your Azure account
Location string Azure region location.
log_bytes_used long Log bytes used.
logical_io_reads long Logical IO reads.
logical_io_writes long Logical IO writes.
max_cpu_time long Maximum CPU time in microseconds.
max_dop long Maximum degree of parallelism.
max_duration long Maximum duration in microseconds.
max_log_bytes_used long Maximum log bytes used.
max_logical_io_reads long Maximum logical IO reads.
max_logical_io_writes long Maximum logical IO writes.
max_num_physical_io_reads long Maximum number of physical IO reads.
max_page_server_reads long Maximum page server reads.
max_physical_io_reads long Maximum physical IO reads.
max_query_max_used_memory long Maximum query maximum used memory.
max_rowcount long Maximum row count.
num_physical_io_reads long Number of physical IO reads.
OperationName string Operation name.
page_server_reads long Page server reads.
physical_io_reads long Physical IO reads.
plan_id long Plan identifier.
query_hash string Query hash.
query_id long Query identifier.
query_max_used_memory long Query maximum used memory.
query_plan_hash string Query plan hash.
replica_group_id long Replica group identifier.
ResourceGroup string Resource group.
_ResourceId string A unique identifier for the resource that the record is associated with
rowcount long Row 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
statement_sql_handle string Statement SQL handle.
_SubscriptionId string A unique identifier for the subscription that the record is associated with
TenantId string The Log Analytics workspace ID
TimeGenerated datetime Timestamp when the log was generated.
Type string The name of the table
  • Last updated on