As the Stored Procedure is just doing INSERT and UPDATE, I have created similar procedure and used two types of Integration Runtime to compare the execution time.
In Case of Azure Integration Runtime ,Tuning the number of cores or choosing a correct memory-optimized configuration can affect performance.
Below setup can be done while creating Azure Integration Runtime:
img1
img2
Now after running the pipelines with two different IRs we are getting significance difference in execution time.
1. AutoResolveIntegrationRuntime
2. Azure Integration Runtime
img3
Also Inside Pipeline Setting, Concurrency can be increased to improve the pipeline performance.
img4
Kindly Go through the attached Microsoft Document for more reference: