Answers are grounded in this paper and cite their sources.
Right-sizing resources for query execution is important for cost-efficient performance, but estimating how performance is affected by resource allocations, upfront, before query execution is difficult. We demonstrate AutoExecutor , a predictive system that uses machine learning models to predict query run times as a function of the number of allocated executors, that limits the maximum allowed parallelism, for Spark SQL queries running on Azure Synapse.
No takes yet. Share an insight, caveat, or question.
Sen et al. (2021) studied this question.
Synapse has enriched 5 related papers. Consider them for comparative context: