Muokkaa

Jaa


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