SQL Latency On-Premises Data Gateway

JV Garcia 1 Reputation point
2020-04-27T02:49:14.657+00:00

Hi

I installed the on-premise data gateway but I found an isssue hard to resolve.

I am trying to execute a SQL stored procedure (svx_adm_buscadni) in Logic Apps via my gateway. When it is executed it takes more than 10 sec, but when I execute it via SQL Management Studio, it takes less than a second.

I followed all recommendations when installing the gateway. Both gateway and Logic Apps are in same region. Latency between database is 1ms.

I am attaching the gateway log. Any help, please?

7702-gatewayinfo20200426000000000.txt

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,672 questions
{count} votes