Edit

Share via

Supported logs for Microsoft.Synapse/workspaces/sqlPools

  • Article

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