Custom DB Query extension not providing the correct count

[tdavison76]

Hello,

I've created a Custom Extension that runs a SQL Query that just provides a "count".  This runs every 1 min, but, the returned count is not accurate.  It should be around 60+ per minute, but Dynatrace is showing single digit counts.  Also, it looks like it skips a minute occassionally.  I can run the query manually in SSMS and see the counts that I expect.

Here's the query:

select count(*) as [count]
from [Mercury].[dbo].[OrderShipmentActual] (nolock)
where [CreateDate] > dateadd(mi, -1, getdate());

Here's how the extension is configured:

Any idea how to resolve this and get the correct counts?

Thank you for any help on this one.

Tom

[AntonioSousa]

@tdavison76 ,

Looks like the missing points might be from timeouts. Normally the timeout is 10 seconds, so put something higher, and let's check afterwards.

[tdavison76]

Hello Antonio, thank you for the help, I've modified the Query and Interval to be 5 min instead of 1.

Still seeing incorrect counts and looks like even more gaps.  e.g.  The below chart is showing a 25 count at 10:05, and the next count is only 2 and doesn't occur until 10:20am.  The SQL Query and 5 min intervals should be showing a count of 300+ every 5 min.

Thanks again for the help

[AntonioSousa]

@tdavison76 ,

You have a timeout of 30 seconds. It cannot be greater than the period, but if you have 5 minutes, try 300 seconds for the timeout.