12
Optimizing and Maintaining Synapse SQL and Spark Pools
In the previous chapter, we learned how to monitor Synapse dedicated SQL and Spark pools. As a natural follow-up to that, in this chapter, we will cover techniques that can optimize the performance of Synapse SQL and Spark pools. In addition to optimization techniques, we will also share maintenance techniques such as pausing Synapse dedicated SQL pools and configuring a longer backup retention duration for Synapse dedicated SQL pools.
By the end of this chapter, you will have learned how to optimize Synapse dedicated SQL pool by reading a query plan and fixing its distribution, building a replication cache, and configuring result set caching. You will also know how to improve Spark ...
Get Azure Data Engineering Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
