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 |
Tilbakemeldinger
https://aka.ms/ContentUserFeedback.
Kommer snart: Gjennom 2024 faser vi ut GitHub Issues som tilbakemeldingsmekanisme for innhold, og erstatter det med et nytt system for tilbakemeldinger. Hvis du vil ha mer informasjon, kan du se:Send inn og vis tilbakemelding for