New view with connection statistics
It would be valuable to have a per-cluster view showing an overview of connections into each cluster including:
- The number of connections per hours (opened, closed == churn)
- Which IPs connections are coming from and how many from each over time
- What drivers are being used for these connections and from which IPs
- Which user is opening the connections
This information can be very useful in understanding which applications/microservices are opening up the most connections, and helping to find old drivers etc.
Nic
shared this idea
-
Buddy
commented
This keeps coming up for up due to misbehaving clients.
It is critical that we identify the number of connections per DB user.Even after a couple of support cases, I still do not know of a way to determine how many DB connections are open for a user.
-
Shawn
commented
I agree that better insight into the Connections would be helpful. Maybe updating the existing "Connections" stats on the Metrics tab to include the counts for "opened" and "closed" connections, alongside the existing "current" connection count?
-
Nic
commented
Yes @Rez that would be great. Maybe filters by appName and driver type would make it possible to drill down and target the root of excessive connections.
-
Thanks Nic - would appName be also useful (if it's passed in the connection string?)
