Refresh/Warm Up Replicated Tables after Resume or Scale Synapse

Mike 21 Reputation points
2021-02-17T06:25:30.54+00:00

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.

Azure Cloud Services
Azure Cloud Services
An Azure platform as a service offer that is used to deploy web and cloud applications.
705 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,059 questions
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,274 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,576 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 32,911 Reputation points MVP
    2021-02-17T06:32:21.54+00:00

    Hey @Mike
    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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.