You’re offline. This is a read only version of the page.
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'
We have the same problem. This query takes from 2 to 13 seconds. It runs constantly several times each minute for each database. We have noticed it is much faster when running as system administrator. Obviously this is a very bad solution so we are considering centralizing the connection in a single, smaller database to avoid the impact of these queries.
Share
Report
All responses (
Answers (
2
