[Info-ingres] Memory Utilisation 98%

[Steve]

On Thursday, September 10, 2020 at 12:56:03 PM UTC+10, Laframboise, André (BAC/LAC) wrote:
> If it's a Linux box, 'free' memory can be misleading. The Linux OS uses as much free memory as possible as I/O buffers. 
> If will free up more memory if needed. 

Thanks André. Installation is running on Solaris.

It's an interesting point you raise. Even though memory usage does get high, it doesn't seem to reach 100% or cause things to fail. I wonder however, if in the past jobs have failed due to memory usage. 

It's a particular time of the day when the memory gets above 95% and there is a particular batch job runnning at that time. That job is not doing anything in the database; I may need to tweak how that batch job works.

> Check the actual memory size of the DBMS processes. If the server is a dedicated Ingres DB server, it would be normal for Ingres to use most of it. 

Yes, it's the box is a dedicated Ingres server.

Thanks
Steve