Logic App Response Timeout

Chris Mancini 1 Reputation point

I have a Logic App that exposes an HTTP Endpoint then calls an on premise SQL Stored Procedure and runs a response action. If I make a call first thing in the morning when it hasnt been called for a while it takes about 6 secs to execute the stored procedure and return the response. If I call it after a recent call it takes milliseconds. It seems that either the on premise data gateway or something else is spinning down or being deallocated from memory. Has anyone else experienced this and if so have any guidance? Thanks in advance.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
1,972 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. MikeUrnun 5,506 Reputation points

    Hello @Chris Mancini

    Have you tried troubleshooting & pinning the timeout down to a specific trigger or action by navigating in the Portal at the Diagnose and solve problems -> Performance tile?