Are you running Cognos on Windows or Linux? If Windows, how often do you reboot the server? I would assume at least monthly if you're applying Windows security updates. We tend to patch every other month unless Microsoft releases a zero-day type critical vulnerability patch. On the months that we don't patch, I still reboot. I've found having Cognos running more than 45-50 days since a reboot starts causing occasional odd issues (transient report failures, unable to authenticate schedule user credentials, etc). Cognos definitely has memory leaks and their java code doesn't seem to do sufficient garbage collection over a long period of time.
Additionally, I'd recommend doing some checking to see how much RAM Cognos is using. We have our Windows (2016 & 2022) servers configured for 64GB. We use SQL Server for our content store and it's installed on the same server as Cognos. It's configured for 10GB RAM. We have the Cognos JVM heap set to 20GB so once things are up and stable we tend to be running with 75% RAM utilization.
If you're running on Linux, be sure to check how much swap is being used. Once swapping starts happening your performance can really tank, especially if you're running the content store on the same server.
Regards,
Wayne
------------------------------
Wayne Westlake
------------------------------
Original Message:
Sent: Wed June 19, 2024 05:45 PM
From: João Alves
Subject: IBM Cognos Analytics Slow
In recent months the advanced report system has been very slow to navigate, before advanced processing was faster, and we have not had any increase in the use of cognos, does anyone have any suggestions on what can be done or analyzed
Note, we increased the RAM to 32GB
------------------------------
João Alves
------------------------------