Multiplex dbo connections queueing up
I most probably need to log an indecent but I just need to get my head around the multiplex inner workings.
We have an IQ 15.4 ESD4.3 multiplex with 3 nodes (1 Query 2 Writer with Coordinator on the one 1 Writer)
As a norm there are 2 dbo connections named IQ_MPX_SERVER_H0 open from each node on the coordinator. When all is well there will be new connections created as
IQ_MPX_SERVER_Pnnn for each node , They execute and go away. Lately we get these connections queuing up and taking a long time to resolve.
This means that the iqgovern slots fill up and the server grinds to a crawl.
Can anybody explain the the process the multiplex follows and what these connections are doing or potentially waiting for?