Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · Logic Apps · 📊
Reference for AzureSQLAutomaticTuning table in Azure Monitor Logs.
| Attribute | Value |
|---|---|
| Category | Workloads |
| Basic Logs Eligible | ✗ No (source) |
| Supports Transformations | ✗ No (source) |
| Ingestion API Supported | ✗ No |
| Lake-Only Ingestion | ✗ No |
| Azure Monitor Tables Reference | View Documentation |
Source: Azure Monitor documentation
| Column Name | Type | Description |
|---|---|---|
| _BilledSize | real | The record size in bytes |
| _IsBillable | string | Specifies whether ingesting the data is billable. When _IsBillable isfalseingestion isn't billed to your Azure account |
| _ResourceId | string | A unique identifier for the resource that the record is associated with |
| _SubscriptionId | string | A unique identifier for the subscription that the record is associated with |
| Category | string | Log category. |
| CreateIndexStateNew | string | New Create Index state. |
| CreateIndexStateOld | string | Old Create Index state. |
| DatabaseModeNew | string | New database tuning mode. |
| DatabaseModeOld | string | Old database tuning mode. |
| DatabaseName | string | Database name. |
| DropIndexStateNew | string | New Drop Index state. |
| DropIndexStateOld | string | Old Drop Index state. |
| ForceLastGoodPlanStateNew | string | New Force Last Good Plan state. |
| ForceLastGoodPlanStateOld | string | Old Force Last Good Plan state. |
| Location | string | Azure region location. |
| LogicalServerName | string | Logical server name. |
| MaintainIndexStateNew | string | New Maintain Index state. |
| MaintainIndexStateOld | string | Old Maintain Index state. |
| OperationName | string | Operation name. |
| ResourceGroup | string | Resource group. |
| SourceSystem | string | The type of agent the event was collected by. For example,OpsManagerfor Windows agent, either direct connect or Operations Manager,Linuxfor all Linux agents, orAzurefor Azure Diagnostics |
| TenantId | string | The Log Analytics workspace ID |
| TimeGenerated | datetime | Timestamp when the log was generated. |
| Type | string | The name of the table |
Official Microsoft Learn documentation for field/column information:
This table collects data from the following Azure resource types:
microsoft.sql/serversBrowse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · Logic Apps · 📊