--- title: Concurrency with Azure Backup for SQL Server description: In this post, we’ll discuss a recent pitfall we came across with backup concurrency, and how this can be avoided with a simple configuration change. image: https://blog.coeo.com/hubfs/nick-fewings-IkjROahgUoo-unsplash.png --- [![](https://www.coeo.com/wp-content/themes/coeo/images/logo.svg)](https://blog.coeo.com/) +44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com) | [Client portal login](https://my.coeo.com) # Concurrency with Azure Backup for SQL Server # The Coeo Blog ![Ben Edwards](https://blog.coeo.com/hubfs/Profile%20photos/BenCircle.jpg) For SQL Server IaaS VMs, Microsoft provides [**Azure Backup for SQL Server**](https://docs.microsoft.com/en-us/azure/backup/backup-azure-sql-database) – a PaaS service allowing you to leverage the Azure Backup service to back up SQL Server databases easily and in a centralised manner. In this post, we’ll discuss a recent pitfall we came across with backup concurrency, and how this can be avoided with a simple configuration change. Background As shown in the image below, Azure Backup uses a workload extension installed on the server to coordinate database backups. The backups are taken using scheduled jobs and are streamed into a Recovery Services vault using VDI. ![Azure Backup Diagram](https://blog.coeo.com/hs-fs/hubfs/Azure-Backup-Diagram.png?width=544&name=Azure-Backup-Diagram.png) ## Problem Suppose you’re using Azure Backup on a SQL Server instance with many databases. In this case, it’s important to know that the workload extension can create up to **20 concurrent backup tasks** at any given time by default. Depending on the size of your databases and the VM resources available, this can cause considerable strain on an instance during the backup window. In our case, the SQL Server in question hit the I/O limits imposed by the Azure disk in use. Whilst upgrading the disk tier is an option, this would increase monthly VM costs, and the additional I/O throughput wasn’t required for the workload (only the backup routine). ## Solution Fortunately, there is a workaround to this issue, as Microsoft provide the ability to control the number of concurrent backup jobs run by Azure Backup through a configuration file and override value: 1. On the SQL Server, create a new file named **ExtensionSettingsOverride.json** in the “C:\\Program Files\\Azure Workload Backup\\bin” directory. This is where the Azure Backup Extension is installed by default. 2. In the JSON file you created, add an entry for **DefaultBackupTasksThreshold**, and set the value lower than the default of 20. In the example below, I set the new threshold to 5. ![](https://blog.coeo.com/hubfs/image-png-3.png) 1. Save and close the file, then restart the **AzureWLBackupCoordinatorSvc** service for the changes to take effect. It’s important to note that this configuration change is a trade-off, as reducing the number of concurrent jobs will increase the overall backup time for an instance. If you see issues with resource usage however, it can be a simple way to tweak backup performance.   [![Enjoyed this blog? Sign up for monthly updates](https://no-cache.hubspot.com/cta/default/3356718/c92a8cd5-326e-4f79-a7b8-5a6ab62c29dc.png)](https://cta-redirect.hubspot.com/cta/redirect/3356718/c92a8cd5-326e-4f79-a7b8-5a6ab62c29dc) ### Subscribe to Email Updates ## Related posts --- ### [Troubleshooting Ola Hallengren’s Maintenance Solution](https://blog.coeo.com/troubleshooting-ola-hallengrens-maintenance-solution) ### [Microsoft Purview's 14 Key Controls](https://blog.coeo.com/data-governance-with-azure-purview-empowering-your-data-governance-with-microsoft-purview-controls-a-comprehensive-guide) ### [Domain-Independent Windows Failover Cluster for SQL Server AlwaysOn Availability Group](https://blog.coeo.com/domain-independent-windows-failover-cluster-for-sql-server-alwayson-availability-group) ### [Three ways to profile data with Azure Databricks](https://blog.coeo.com/three-ways-to-profile-data-with-azure-databricks) ![](https://www.coeo.com/wp-content/uploads/2016/12/logo-invert.png) +44 (0)20 3051 3595 | info@coeo.com ## Contact Us By clicking submit below, you consent to allow Coeo to store and process the personal information submitted above to provide you the content requested. You may unsubscribe from these communications at any time. For more information on how to unsubscribe and our commitment to your privacy, please review our **[Privacy Policy](https://www.coeo.com/privacy/)**. ## Upcoming Events [See all events](https://www.coeo.com/events/) #### NOW Building, Thames Valley Park Drive, Reading, RG6 1RB [![](https://www.coeo.com/wp-content/themes/coeo/images/social-glass.png)](https://www.glassdoor.co.uk/Overview/Working-at-Coeo-EI_IE959052.11,15.htm)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-in.png)](https://www.linkedin.com/company/coeo-ltd)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-twitter.png)](https://twitter.com/CoeoLtd)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-fb.png)](https://www.facebook.com/coeoltd/) ![](https://www.coeo.com/wp-content/themes/coeo/images//menu-icon.png) ![](https://www.coeo.com/wp-content/themes/coeo/images//menu-close.png) ![](https://www.coeo.com/wp-content/uploads/2016/12/logo-invert.png) +44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com) - [Solutions](https://www.coeo.com/solutions/) - [Next Steps](https://www.coeo.com/next-steps/) - [Dedicated Support](https://www.coeo.com/dedicated-support/) - [Case studies](https://www.coeo.com/case-studies/) - [Technologies](https://www.coeo.com/solutions/technologies/) - [Industries](https://www.coeo.com/industries/) - [Finance](https://www.coeo.com/industries/finance/) - [Retail](https://www.coeo.com/industries/retail/) - [Technology](https://www.coeo.com/industries/technology/) - [The Team](https://www.coeo.com/people/) - [Join Us](https://www.coeo.com/careers/) - [Graduate Programme](https://www.coeo.com/graduate-programme/) - [About Coeo](https://www.coeo.com/about-coeo/) - [The Coeo Blog](https://www.coeo.com/blog/) - [Contact us](https://www.coeo.com/contact-us/) - [Privacy Notice](https://www.coeo.com/privacy/) - [Cookie Policy](https://www.coeo.com/privacy#Cookie_Policy) - [Events](https://www.coeo.com/events) Sign up to our newsletter ![go arrow](https://www.coeo.com/wp-content/themes/coeo/images/newsletter-go.png) Back to top