Express Provisioning of Azure-SSIS Integration Runtime
Published Jun 24 2019 11:43 PM 7,948 Views
Microsoft

As we continue to improve customer experience in using Azure-SSIS Integration Runtime (SSIS IR), we are excited to announce that SSIS IR can now be provisioned within 5 minutes!

 

In the past, provisioning SSIS IR took at least 20-30 minutes.  This is because the underlying nodes/Virtual Machines (VMs) would have to be created and prepared just in time from scratch, leading to the prolonged 20-30 minutes duration.   This has been a customer pain point, especially when demoing/trying out SSIS IR as a Proof of Concept (PoC) that needs to be done quickly.

 

Now SSIS IR creation can leverage pools of standby VMs that have been created and prepared in advance.  The standby VM types and quantities are chosen based on historical data.  When there is a provisioning request for SSIS IR, its VMs are allocated from a pool of standby VMs.  As a result, the provisioning time is now reduced by around 80%.

 

At present, our express provisioning can support all SSIS IRs outside a Virtual Network (VNet), with or without custom setups that can be configured following this documentation.  Due to current technical limitations, standby VMs cannot be leveraged to shorten the provisioning time of SSIS IRs joining/inside a VNet.

 

Based on our recent monitoring, more than 95% of SSIS IR creations outside a VNet have benefited from our express provisioning and excluding any custom setup time, more than 95% of them have been provisioned in under 5 minutes.

 

We hope you will find this improvement useful.  Please do not hesitate to contact us if you have any feedbacks/questions/issues and we will follow up ASAP.  Thank you as always for your support.

19 Comments
Version history
Last update:
‎Jun 24 2019 11:55 PM
Updated by: