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.
643 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.
4,395 questions
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,124 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,381 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 29,891 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