Efficient solutions to improve Azure SQL Database deployment
I have a bacpac file placed in a storage account. For each request, a function app will be executed using New-AzSqlDatabaseImport method to deploy a new database based on the bacpac file.
The number of requests can be many at the same time, and the destination SQL server is located in different regions.
I am encountering an issue where the function is not stable; it is slow, prone to errors, and sometimes never completes. This occurs during certain times of the day due to the limitation that ‘The Azure SQL Database Import/Export service provides a limited number of compute virtual machines (VMs) per region to process import and export operations’ (source: Azure SQL Database Import/Export service documentation).
My questions are:
- Are there efficient ways to improve the stability and performance of the deployment?
- I am aware of the solution using ARM template deployment with a bacpac file. Will this approach address the mentioned limitation?
Read more here: Source link
