AnsweredAssumed Answered

What would make RTQP queries  intermittently Time out. The first execution returns in 2 seconds the next Times out. We recently updated the Server . How Can I detect what the problem really is.

Question asked by RandolphT on Aug 12, 2020
Latest reply on Aug 13, 2020 by gregor

Select top 50 * from [MASTER].[ELEMENT].[Attribute] ea

INNER JOIN [MASTER].[ELEMENT].[ARCHIVE] a ON a.ATTRIBUTE= ea.ID

 and ELEMENT = 'XXXXXXX' 

and NAME like  '%7-7%'

Where a.TIMESTAMP BETWEEN '04/27/2019' AND '05/19/2019'

 

Intermittent Performance either 2 seconds or not at all

 

Issue 2

This query returns different results every time I run the Query

seems like it only returns 2020  or 2019 ##intermittently### changing between the 2

Select top 1 * from [MASTER].[ELEMENT].[Attribute] ea

INNER JOIN [MASTER].[ELEMENT].[ARCHIVE] a ON a.ATTRIBUTE= ea.ID

 and ELEMENT = 'XXXXXXX' 

and NAME like  '%7-7%'

Where a.TIMESTAMP >= '04/27/2019' 

Order by a.Timestmp ASC

Outcomes