Skip to main content

Hi,

in Azure SQL Database in Query Performance Insight → Long Running Queries I have a query (see screenshot) and I can’t seem to find what is triggering this query. In the second screenshot you can see that every execution takes about 7 seconds.

I have an item table with a system versioning table called item_history in Azure database but I already checked in Software Factory if there is anything that could trigger the query but can’t seem to find anything.

Does someone have an explanation for this ? Or can give me some pointers to look elsewhere.

Thank you.

 

Query in text:

SELECT "tsf_valid_from],itsf_valid_to],a$S],t$tabType] FROM (SELECT  tsf_valid_from],itsf_valid_to],LAG (ttsf_valid_to]) OVER (PARTITION BY Iitem_id] ORDER BY Otsf_valid_from],itsf_valid_to]) AS _$S], $tabType] FROM (SELECT  item_id],itsf_valid_from],itsf_valid_to], 0 AS o$tabType] FROM pdbo].Oitem_history] UNION ALL SELECT Litem_id],itsf_valid_from],itsf_valid_to], 1 AS o$tabType] FROM pdbo].Oitem]) AS R) AS T

 

query item_history from Azure 
duration and executions of query

 

Kind regards,

Tim

Did you check for any outside sources? Reporting, an external application, an api etc. 


Hi @tim, can you please respond to the question Erwin asked? Thanks!