azure data factory - copy activity

Question

Hi All,

While doing copy activity from on-prem SQL to Azure SQL DB, does it impact to on-prem SQL performance?
I don't care the performance of copy activity, but just worrying about the performance of SQL DB on-prem.

If it impacts to on-prem SQL DB, is there any way to minimize the impact of SQL DB?

Answer 1

Hi anonymous user ,

Thank you for posting query in Microsoft Q&A Platform.

To fetch data from on-prem SQL you need to consider installing Selfhosted IR to an on-prem machine or virtual machine with in your on-prem network.

This selfhosted IR uses resources from on-prem environment to perform data movement. Hence to make sure your on-prem sql performance not to degrade, consider installing selfhosted IR in different machine. Don't install selfhosted IR in the same machine where your SQL data source is present.

Please check below documentation that helps to understand better.
Considerations for using a self-hosted IR

Hope this helps. Please let us know if any further queries.

---------
Please consider hitting Accept Answer. Accepted answers help community as well.