Supported logs for Microsoft.Synapse/workspaces/sqlPools
The following table lists the types of logs available for the Microsoft.Synapse/workspaces/sqlPools resource type.
For a list of supported metrics, see Supported metrics - Microsoft.Synapse/workspaces/sqlPools
| Category | Category display name | Log table | Supports basic log plan | Supports ingestion-time transformation | Example queries | Costs to export |
|---|---|---|---|---|---|---|
DmsWorkers |
Dms Workers | SynapseSqlPoolDmsWorkers Information about workers completing DMS steps in an Azure Synapse dedicated SQL pool. |
Yes | Yes | No | |
ExecRequests |
Exec Requests | SynapseSqlPoolExecRequests Information about SQL requests or queries in an Azure Synapse dedicated SQL pool. |
Yes | Yes | No | |
RequestSteps |
Request Steps | SynapseSqlPoolRequestSteps Information about request steps that compose a given SQL request or query in an Azure Synapse dedicated SQL pool. |
Yes | Yes | No | |
SqlRequests |
Sql Requests | SynapseSqlPoolSqlRequests Information about query distributions of the steps of SQL requests/queries in an Azure Synapse dedicated SQL pool. |
Yes | Yes | No | |
SQLSecurityAuditEvents |
Sql Security Audit Event | SQLSecurityAuditEvents Azure Synapse SQL Audit Log. |
No | Yes | No | |
Waits |
Waits | SynapseSqlPoolWaits Information about the wait states encountered during execution of a SQL request/query in an Azure Synapse dedicated SQL pool, including locks and waits on transmission queues. |
Yes | Yes | 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)