topic Database instances in Dynatrace Managed in Cloud platforms

Database instances in Dynatrace Managed

s_guermach — Wed, 21 Aug 2024 11:08:01 GMT

We are a heavy user of azure SQLServer databases in our environments.

We observe that dynatrace is creating multiple instances for one and the same DB.

This is apparently because the DNS resolution in azure, returns different IPs. Also apparently azure can migrate the server from one instance to another resulting in dynatrace creating more DB instances. This is making our live harder tracking DB calls, throughput, error rates .. etc as they can be in any of these DB instances in dynatrace. There should be some way of ignoring the IP when identifying a DB in azure, and the database instance should be identified only by DNS name, which is always unique.

Re: DB instances in dynatrace managed

tibebe_m_digafe — Thu, 25 Nov 2021 00:49:11 GMT

We got the same issue with AWS RDS mult-AZ DB instances. We see more than one DB services post instance failover in AWS. Even worse, the DB service that should have been marked as inactive (if updating is an issue) could be showing associated with 2 DB instances (or more) if the "IP address" of the DB instance prior to failover gets re-assigned to another DB instance in AWS.

Re: DB instances in dynatrace managed

tibebe_m_digafe — Thu, 25 Nov 2021 00:49:42 GMT

I have opened a support ticket for this

Re: DB instances in dynatrace managed

Santosh — Tue, 29 Nov 2022 09:10:50 GMT

Is there any specific solution did you received from support team?

Re: DB instances in dynatrace managed

tibebe_m_digafe — Tue, 29 Nov 2022 13:35:24 GMT

No specific solutions was provided at the time. I suspect you experienced the same recently which suggests the issue has not yet been addressed.

I have not heard from my users for a while. I have not tested either in recent time.

Tibebe

Re: DB instances in dynatrace managed

Santosh — Tue, 29 Nov 2022 14:17:43 GMT

Thanks for your reply, yes I am getting same problem while moitoring DB's with dynamic IP's, whenever there is change is IP it creates the new service or there are multiple services are created for same DB

Re: DB instances in dynatrace managed

tibebe_m_digafe — Tue, 29 Nov 2022 14:36:22 GMT

I went back to the case I had opened at the time to find out more details:

They had me open RFE - https://community.dynatrace.com/t5/Dynatrace-product-ideas/Database-service-detection-not-reflecting-changes-in-underlying/idi-p/185892#M29843

You can vote up the RFE, and appreciate if others can do the same

Tibebe