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 | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | 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 |
Next Steps
- Learn more about resource logs
- Stream resource logs to Event Hubs
- Change resource log diagnostic settings using the Azure Monitor REST API
- Analyze logs from Azure storage with Log Analytics
- Optimize log queries in Azure Monitor
- Aggregate data in a Log Analytics workspace by using summary rules (Preview)