Did You Know…TempDB Size in Azure Synapse Dedicated SQL Pool (SQL DWH)

This post is a part of the series “Did You Know” whereby the purpose is to share some quick key point of a particular concept that helps us to be informed on top of our head or something that we want to be revisited quickly. So, no detailed discussions on the topic but a straight finding about it in a line or two.

For each 100 compute units i.e. DW100c, 399GB of tempdb space is allocated so if you have configured it for say DW1000c units then your tempdb can grow up to 3.99TB of total space.

Leave a Reply