Pipeline activity Stored Procedure started taking a lot of time

[anosul]

Dear Community,

My pipeline that uses the [Stored Procedure] activity started taking a lot of time.

I have a simple SQL stored procedure and execution time on the SQL Server side is less than 1 sec.
I created a pipeline and used activity [Stored Procedure] that calls this stored procedure.
And during the last month, everything has worked as expected.

Today, execution time is more than 4-5 minutes.

My pipeline has approximately 20 [Stored Procedure] activities, so execution time increased by more than 1 hour.

I checked the stored procedure and the execution time on the SQL Server side is still less than 1 sec.
I also checked the configuration of the pipeline and any changes weren't found.
We don't have any performance or network issues. Capacity resources are not overloaded either.

As a workaround, we changed activity [Stored Procedure] to [Script] and the execution time returned to expected.

Maybe someone can share the experience of how we can avoid such situations or provide some details related to this issue.

Thank you

[anosul · Accepted solution]

After the weekend, the issue with [Stored Procedure] activity does not reproduce in the pipeline.

I've returned the initial configuration and the execution time returned to expected.
Maybe we had some updates at the tenant level or some magic happened, but right now, everything functions properly.

We added additional monitoring on sources, storage, and pipelines, and let's hope such a challenge won't happen one more time.

[Anonymous]

Hi @anosul ,

Glad to know that your issue got resolved. May be it looks like an intermittent issue. Please let us know incase if you face a similar issue in future.

Thank you