We've had this question since day 1 but thought I'd get some community feedback on it.
In my organization there are some central database that many departments connect to. They can use all different types of connection strings to access this database. We're trying to use Dynatrace's Database monitor though to get a overarching view regarding the database's performance.
Problem is, you can't do that. Dynatrace splits up the metrics based on the connection string used.
In this image, Dynatrace reports 7 databases under say the name "CoolDB" for which there is a a CoolDB_PRD (Green) and a CoolDB_TST (Orange). But users connect to each with different connection strings. Thus what is really 2 database, Dynatrace presents as 7.
For us to understand all the things the Production Database is doing I have to go into 4 different entities in Dynatrace. This is really counter-productive to monitoring our Production database.
I can't go out and tell all the developers to use the same connection string, that's just not something you can do in our environment.
Any thoughts on how to better configure Dynatrace so i can get a better single pane of glass on this?
I'm hoping that this recent post of mine,
might help here, but have got no replies yet... If you are able to try, it might help 😉