question

Mike-3952 avatar image
0 Votes"
Mike-3952 asked AmeliaGu-msft edited

Refresh/Warm Up Replicated Tables after Resume or Scale Synapse

Hi. I'm using Automation Account runbook to Resume Dedicated SQL pool (formerly SQL DW). Do I need to warm up replicated tables after resume or scale to increase query performance against those tables? Can I do it with Automation Account runbook? Could anyone share that kind of runbook? Thank you in advance.

windows-server-powershellazure-synapse-analyticsazure-automationazure-cloud-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered

Hey @Mike-3952
The concept of replicated tables is it is distributed across all distributions.
So there is no specific need to do anything once you pause and resume ideally.

But you can create statistics if needed but ideally for replicated tables I would suggest those are not needed.
let synapse create them automatically if needed

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.