I want to know about PWH setting of max_connections.
I got the answer "The default maximum number of connections between the Dynatrace Server and Performance Warehouse database is 100." from support.
but if I have huge environment, should I setting the number?
Is not it common that the number of simultaneous connections exceeds 100?
We are looking for topic to consider when introducing dynatrace on a large system of production environment.
you'll have to increase the value if you think that you'll have a lot of clients (say, more than 30) charting (or refreshing charts) at the same time. Our connection pools by default reserve 50 connections (each, backend and fronted server), you can modify this number by setting the debug flag
to a number of your choice (the default is 50, per server, so you have to provide double this number from the db side).
Thank you for your answer!
However, I want to know more detail.
You are raising cases where there are many clients as an example, but our environment is three clients.
However, If I open many chart dashlets, does the number of simultaneous connections increase?
■ Please tell me the conditions that will increase the number of concurrent database connections on one client.
■ Is there an upper limit on the number of DB simultaneous connections per client?
■ Please tell me about the behavior when I exceed the number of DB simultaneous connections.
"per server" means 50 for the backend server and 50 for the frontendserver.
This is the only debug flag. When you set it, disconnect/connect the pwh to activate it.
The most reliable way to check how many connections are currently open is from the database side. We also offer jmx metrics for the connection pool (basically just forwarding the pool's built in metrics). Check with jconsole (you need to make sure that the JMX service is enabled on the backend server). Best regards,