Synapse doesn't have the notion of locking.
Running mixed workloads can pose resource challenges on busy systems. We need to separate classic data warehousing activities (such as loading, transforming, and querying data) to ensure that enough resources exist to hit SLAs.
Synapse SQL pool workload management in Azure Synapse consists of three high-level concepts:
- workload classification
- workload importance
- influences the order in which a request gets access to resources.
- workload isolation.