Box 1: A Get Metadata activity

Dynamically size data flow compute at runtime

The Core Count and Compute Type properties can be set dynamically to adjust to the size of your incoming source data at runtime. Use pipeline activities like Lookup or Get Metadata in order to find the size of the source dataset data. Then, use Add Dynamic Content in the Data Flow activity properties.

Box 2: Dynamic content

SynapseSqlPoolExecRequests:

This log contains detailed information about queries executed in a dedicated SQL pool in Azure Synapse Analytics.

It provides metrics such as query duration, CPU time, I/O, and the status of the queries, making it the best choice for monitoring query performance.

Other options:

A. SynapseSqlPoolSqlRequests:

Logs high-level requests, such as login attempts or connection establishment. It doesn’t give detailed query execution information.

C. SynapseSqlPoolWaits:

Contains information about waits in the SQL pool, useful for troubleshooting resource contention but not suitable for directly monitoring query performance.

D. SynapseSqlPoolRequestSteps:

Provides information about the individual steps within a query plan, which is more granular and not typically used for general query performance monitoring.