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)