- # of connections used by each pod to identify the optimizing opportunities
Background & Goal:
There are too many inactive sessions in the database coming from OpenShift and GKE. One action we've taken is to create a new app id with access controls app id for apps going to GKE. If feasible, this analytical report will help to find the gap and optimization points. Awareness: In the database, DBA team can name the app name and where the connection is coming from. Our challenge is that DBAs cannot determine who the app owners are or what their pod configurations are.
some of this stuff is going to be centric to your organization and not really be auto discovered such as your app team owner. You should be able to get the bulk of this via the API Metric Explorer, its not going to get you everything you want but its a start that's for use.