Monitoring and rebuilding a replication table cache

Replication tables in Synapse dedicated SQL pool are tables that are copied to all the compute nodes and the control node of a Synapse dedicated SQL pool. So, if a Synapse dedicated SQL pool contains three compute nodes, then four copies of the replicated table are present in the database. A replication table prevents the Synapse engine from broadcasting a table across all compute nodes during query processing. However, the replication table would be effective and would prevent broadcast operations when the replication table cache is in the Ready state.

This recipe will teach you how to monitor the state of a replication table cache and rebuild the cache for all the replication tables in your Synapse dedicated SQL pool database.

Getting ready

To get started, log into https://portal.azure.com using your Azure credentials.

Create a Synapse Analytics workspace, as explained in the Provisioning an Azure Synapse Analytics...