Categories
Synapse

When Hash Keys Skew Synapse Tables

In Synapse SQL Pools, Hash distributions allow us to somewhat control data distribution. Whilst this can deliver performance in the right scenarios, I noted last week that these tables should be monitored to avoid skew. In this post I want to demonstrate how to identify the skew, and why a different distribution model may be […]

Categories
Synapse

Why Table Distribution Matters in Synapse SQL Pools

When designing tables in a Synapse Dedicated SQL Pool, I initially focussed on the ‘SQL’ and not so much the ‘pool’. How tables are stored is fundamentally different to other Azure SQL offerings, so it’s easy to get tripped up and impact efficiency and performance. Let’s see how the SQL pools work differently and how […]