AzureSQLResourceUsageStats

Resource Usage 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
avg_cpu_percent string Average CPU percentage.
_BilledSize real The record size in bytes
Category string Log category.
io_bytes_read string IO bytes read.
io_bytes_written string IO bytes written.
io_requests string Number of IO requests.
_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.
OperationName string Operation name.
reserved_storage_mb string Reserved storage in MB.
ResourceGroup string Resource group.
_ResourceId string A unique identifier for the resource that the record is associated with
SKU string Service tier SKU.
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
storage_space_used_mb string Storage space used in MB.
_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
virtual_core_count string Virtual core count.