Microsoft.Synapse/workspaces/sqlPools
6 diagnostic categories routing into 6 Log Analytics tables.
Source: Microsoft Learn
Diagnostic categories
-
DmsWorkers
Dms Workers
Basic Logs Ingestion-time transform- Routes to
- SynapseSqlPoolDmsWorkers
-
ExecRequests
Exec Requests
Basic Logs Ingestion-time transform- Routes to
- SynapseSqlPoolExecRequests
-
RequestSteps
Request Steps
Basic Logs Ingestion-time transform- Routes to
- SynapseSqlPoolRequestSteps
-
SqlRequests
Sql Requests
Basic Logs Ingestion-time transform- Routes to
- SynapseSqlPoolSqlRequests
-
SQLSecurityAuditEvents
Sql Security Audit Event
Ingestion-time transform PII- Routes to
- SQLSecurityAuditEvents
-
Waits
Basic Logs Ingestion-time transform- Routes to
- SynapseSqlPoolWaits
Destination tables
-
SQLSecurityAuditEvents
PIIAzure Synapse SQL Audit Log.
56 columns in this table.
-
SynapseSqlPoolDmsWorkers
Information about workers completing DMS steps in an Azure Synapse dedicated SQL pool.
28 columns in this table.
-
SynapseSqlPoolExecRequests
Information about SQL requests or queries in an Azure Synapse dedicated SQL pool.
33 columns in this table.
-
SynapseSqlPoolRequestSteps
Information about request steps that compose a given SQL request or query in an Azure Synapse dedicated SQL pool.
24 columns in this table.
-
SynapseSqlPoolSqlRequests
Information about query distributions of the steps of SQL requests/queries in an Azure Synapse dedicated SQL pool.
23 columns in this table.
-
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.
17 columns in this table.