Logic App Response Timeout

Chris Mancini 1 Reputation point
2021-06-25T13:30:22.24+00:00

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.
2,996 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Mike Urnun 9,786 Reputation points Microsoft Employee
    2021-06-30T01:43:13.69+00:00

    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?

    110414-image.png