SQL Latency On-Premises Data Gateway

JV Garcia 1

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

KalyanChanumolu-MSFT 8,316 Reputation points

2020-04-27T11:08:44.03+00:00

Does the stored procedure return data back?
If yes, the size of the record set could be contributing to the time when measured from the Logic App.

Also, how busy is your Data gateway? Are there other apps and services using it at the same time?
JV Garcia 1 Reputation point

2020-04-27T12:01:42.303+00:00

Hi again! Yes, it returns data back. My stored procedure is a very simple one. It just returns name, phone numbers and a couple of things more from a single person.

Data gateway is not busy at all. It has no load. No other apps o services running.

I forgot to tell I have another data gateway server in my infrastructure, but connected to another tenant. That one seems to run well.