topic Re: Custom DB Query extension not providing the correct count in Extensions

Custom DB Query extension not providing the correct count

tdavison76 — Tue, 21 Jul 2026 12:59:30 GMT

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

Re: Custom DB Query extension not providing the correct count

AntonioSousa — Tue, 21 Jul 2026 13:26:03 GMT

@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.

Re: Custom DB Query extension not providing the correct count

tdavison76 — Tue, 21 Jul 2026 14:26:42 GMT

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

Re: Custom DB Query extension not providing the correct count

AntonioSousa — Wed, 22 Jul 2026 08:14:55 GMT

@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.