SQL Change Automation is really slow on SQL Azure
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?
0 · Share on Twitter