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?
Comments
1 comment
-
Hi @...,
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
Add comment
Please sign in to leave a comment.