Power Platform Community Forum Thread Details

Hi,

I want to use on-premises data gateway to connect Logic Apps with my SQL Server. The issue is that when I execute a SP, it takes like 10s. If I do it via SQL Management Studio it takes less than a 1ms.

My DBA tells that latency is due to a query that sends the gateway every time before my SP runs. Please it see below.

Anybody knows where this query comes from and how to avoid it?

Thanks in advance!

select r.[ROUTINE_SCHEMA], r.[ROUTINE_NAME], r.[ROUTINE_TYPE], p.create_date [CREATED_DATE], p.modify_date [MODIFIED_DATE], cast(e.value as nvarchar(max)) [DESCRIPTION]

from [INFORMATION_SCHEMA].[ROUTINES] r

join sys.schemas s on s.name = r.[ROUTINE_SCHEMA]

join sys.objects p on p.name = r.[ROUTINE_NAME] and p.schema_id = s.schema_id and p.parent_object_id = 0

left outer join sys.extended_properties e on p.object_id = e.major_id and e.minor_id = 0 and e.class = 1 and e.name = 'MS_Description'

Categories:

General topics