Supported logs for Microsoft.Sql/servers/databases
The following table lists the types of logs available for the Microsoft.Sql/servers/databases resource type.
For a list of supported metrics, see Supported metrics - Microsoft.Sql/servers/databases
Category | Category display name | Log table | Supports basic log plan | Supports ingestion-time transformation | Example queries | Costs to export |
---|---|---|---|---|---|---|
AutomaticTuning |
Automatic tuning | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
Blocks |
Blocks | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
DatabaseWaitStatistics |
Database Wait Statistics | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
Deadlocks |
Deadlocks | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
DevOpsOperationsAudit |
Devops operations Audit Logs | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
DmsWorkers |
Dms Workers | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
Errors |
Errors | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
ExecRequests |
Exec Requests | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
QueryStoreRuntimeStatistics |
Query Store Runtime Statistics | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
QueryStoreWaitStatistics |
Query Store Wait Statistics | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
RequestSteps |
Request Steps | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
SQLInsights |
SQL Insights | No | No | No | ||
SqlRequests |
Sql Requests | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
SQLSecurityAuditEvents |
SQL Security Audit Event | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
Timeouts |
Timeouts | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
Waits |
Waits | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |