Summary
As the usage of your Azure Synapse workspace grows, you may start to experience throttling errors at peak times due to extensive use of the compute resources in your Data Explorer pools. Having a plan to address resource usage through workgroup policies helps you better control the user experience and offer a balanced environment for all users. In addition to that, using techniques that help you speed up user queries helps you relieve stress on the platform, and resolve some requests more rapidly.
In this chapter, you learned how to implement resource governance to limit resource usage depending on who the user submitting the request is, the application that they are using, the description submitted with the request, and more. You learned how to create workload group policies, classify user requests to these policies, and enable the queueing of requests that are throttled for delayed execution.
You also learned how to pre-cache data to speed up queries. We explored the...