Azure SQL Database
An Azure relational database service.
5,910 questions
Slow execution of Stored Procedure Activity in Azure Data Factory
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 47%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
chowdar
0
Reputation points
I am experiencing issues with the Stored Procedure Activity in Azure Data Factory. After the completion of a copy activity, the stored procedure activity triggers and goes into an in-progress state, but it does not start executing in SQL Server for up to an hour. after an hour it started execution. Can anyone help me understand why this is happening?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 12%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Revathi 0 Reputation points2023-12-30T10:44:31.3833333+00:00 Even i have same issue
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Subashri Vasudevan 11,206 Reputation points2023-12-30T10:47:28.6+00:00 Hi Chowder, can you please confirm if this is the first time you are seeing this issue or it is consistent in every run? Also pls let us know in which region you face this issue. And also type of integration runtime used.
-
chowdar 0 Reputation points
2023-12-30T13:19:22.3466667+00:00 Hi @Subashri Vasudevan ,
Every run facing same issue. total integration run time is 1hr40min, in this Single procedure taking 1hr10min. total 100 tables running(dynamic) in this integration and, but it is affecting for only specific one. and all other also same pattern. when running alone it completed within minutes.
-
Subashri Vasudevan 11,206 Reputation points
2023-12-30T13:23:47.85+00:00 Pls tell the region where your data factory is created
-
chowdar 0 Reputation points
2023-12-30T13:27:05.11+00:00 Us region
-
Subashri Vasudevan 11,206 Reputation points
2023-12-30T16:22:29.6966667+00:00 I don't see any active issue going on in US region.
It needs more investigation. It could be related to Integration runtime/ specific to your source database.
Looping @KranthiPakala-MSFT
-
AnnuKumari-MSFT 33,986 Reputation points Microsoft Employee2024-01-04T07:25:37.3766667+00:00 Hi chowdar ,
Which integration runtime are you using? Self hosted or Azure IR?
Sign in to comment
Sign in to answer