SQL Change Automation is really slow on SQL Azure

MackWhitney

We're just getting going with SQL Change Automation and find that deployments take a while (north of 15 minutes). The rest of our CI/CD pipeline is a lot quicker and SCA is holding us back. We've noticed that the tempdb that SCA spins up is a Basic 5 DTU instance. Can we make the process any faster? Would it be any faster if we could get that Basic instance to a Standard? 

Kurt_M

Hi @MackWhitney,

My recommendation for the shadow database would be to actually create it on a local instance if at all possible. This should speed up your deployment as it won't be bottlenecked by the speed in Azure. 

If that is not a possibility, then changing from the basic instance to a standard instance might be the increase you require.

I'd recommend having a read of this page in our documentation which talks about the performance of the SQL Change Automation shadow database:

https://documentation.red-gate.com/sca/developing-databases/concepts/shadow-database