Optimizing resource management

Optimizing resource management in this context refers to how to reduce your billing expenses while using Azure analytic services. Here are some of the general techniques that can help.

Optimizing Synapse SQL pools

Here are a few suggestions for Synapse dedicated SQL pools:

• Since the storage and compute are decoupled, you can pause your SQL pool compute when not in use. This will not impact your data but will save you some costs.
• Use the right size of compute units. In the SQL pool, the compute units are defined in terms of Data Warehouse Units (DWUs). You can start with the smallest DWU and then gradually increase to higher DWUs to strike the right balance between cost and performance.
• Manually scale out or scale in the compute resources based on the load. You can also automate the scale-out and in using Azure Functions.

You can learn more about resource management optimizations for the SQL pool here: https://docs.microsoft...