Microsoft.Sql/servers/databases
16 diagnostic categories routing into 2 Log Analytics tables.
Source: Microsoft Learn
Diagnostic categories
-
AutomaticTuning
Automatic tuning
- Routes to
- AzureDiagnostics
-
Blocks
- Routes to
- AzureDiagnostics
-
DatabaseWaitStatistics
Database Wait Statistics
- Routes to
- AzureDiagnostics
-
Deadlocks
- Routes to
- AzureDiagnostics
-
DevOpsOperationsAudit
Devops operations Audit Logs
- Routes to
- AzureDiagnostics
-
DmsWorkers
Dms Workers
- Routes to
- AzureDiagnostics
-
Errors
- Routes to
- AzureDiagnostics
-
ExecRequests
Exec Requests
- Routes to
- AzureDiagnostics
-
QueryStoreRuntimeStatistics
Query Store Runtime Statistics
- Routes to
- AzureDiagnostics
-
QueryStoreWaitStatistics
Query Store Wait Statistics
- Routes to
- AzureDiagnostics
-
RequestSteps
Request Steps
- Routes to
- AzureDiagnostics
-
SQLInsights
SQL Insights
- Routes to
- AzureDiagnostics
-
SqlRequests
Sql Requests
- Routes to
- AzureDiagnostics
-
SQLSecurityAuditEvents
SQL Security Audit Event
PII- Routes to
- AzureDiagnostics
- Per-category table
- SQLSecurityAuditEvents
-
Timeouts
- Routes to
- AzureDiagnostics
-
Waits
- Routes to
- AzureDiagnostics
Destination tables
-
AzureDiagnostics
PIIStores resource logs for Azure services that use Azure Diagnostics mode. Resource logs describe the internal operation of Azure resources.
174 columns in this table.
-
SQLSecurityAuditEvents
PIIAzure Synapse SQL Audit Log.
56 columns in this table.