I have an Agent on which the SLDataGateway process is consuming all the available memory. How can I start investigating why this process is using approx. 20GB of memory?
Hello,
I'd always start with checking the SLDatagateway.txt & sldbconnection.txt. These might mention some queues going up. For example, trending might be out of control, elementdata might be spiking.... If the loggings do not indicate an issue, I would take a memory dump of SLDatagateway and check with the development team to see what is going on.
Hi Jens,
In the past Ruben enabled the offload of the database queries to a file, to see what data was being written to the database.
Perhaps this can help you with this investigation?
Hi Folks, could you please share the solution?
thanks
Thank you Jens, i was just curious on what have worked for them.
best regards
Hi Euler,
Unfortunately there is no generic solution for this. When a process has a memory leak, then this can have many root causes, and there can be a variety of ways to address that. Therefore each case has to be considered separately.
The answer from Thomas will help you to find the root cause.