How can I investigate why SLDataGateway is consuming all available memory

Solved1.91K viewsSLDataGateway
3
0 Comments

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?

Euler Peron [DevOps Member] Answered question 4th January 2021

3 Answers

6
286 0 Comments

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.

Jens Vandewalle [SLC] [DevOps Enabler] Selected answer as best 23rd December 2020
3
13.84K 0 Comments

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?

Ive Herreman [SLC] [DevOps Enabler] Answered question 23rd December 2020
0
107 2 Comments

Hi Folks, could you please share the solution?

thanks

Euler Peron [DevOps Member] Posted new comment 11th January 2021
Jens Vandewalle [SLC] [DevOps Enabler] commented

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.
Euler Peron [DevOps Member] commented

Thank you Jens, i was just curious on what have worked for them.

best regards