question

JVGarcia-7916 avatar image
0 Votes"
JVGarcia-7916 asked bhargaviannadevara-msft edited

SQL Latency On-Premises Data Gateway

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-supported
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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?

0 Votes 0 ·

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.

0 Votes 0 ·

0 Answers