Gaps in metrics for custom SQLServer extension 2.0

[todd_dzur2]

Hi,

We have a custom sqlServer extension and have noticed strange behaviour in how metrics are showing up in Data explorer. 
As part of troubleshooting, we have simplified the query for testing purposes and still notice missing gaps in the graphs constantly. 

There are no errors in the Log viewer within Dynatrace, it also shows that it is polling every minute. There are no errors in the logs from remotepluginmodule\log\extension\datasources.

Are there any additional ways to troubleshoot these extensions or increase the logging level to confirm where the issue might be?
 

 

[AntonPineiro]

Hi,

Do this gaps appears in more databases? Or only one?

Just to be sure issue is in ActiveGate or target machine.

Best regards

[todd_dzur2]

I've added this to another applications SQL Server, using a different set of Active Gates and I'm still seeing the same issue with gaps in metrics

I don't see issues with metrics for the dynatrace provided Microsoft SQL Server Extension

[AntonPineiro]

Hi,

It means, you have issue in one Active group and no issue in another group? Is that?

Best regards

[rastislav_danis]

Try to visualize count aggregation of your metric, maybe 2 datapoints fell into same 1 minute bucket.

[todd_dzur2]

I have tried sum and count. The count always shows 1, the sum is the same as the average. 

I changed the interval to 2 minutes, and it's still missing metrics (eg, 4 minutes between some data points).

Issues are with both activegate groups and different SQL servers. The only thing in common is they are on the same Managed cluster. I would have thought that if there were issues with the cluster, we would also see missing metrics with the Dynatrace provided extensions.

[rastislav_danis]

seems strange, have you tried to check dsfm metrics like dsfm:server.metrics.ingest.external_datapoints to see if proper number of datapoints is ingested from your extension?