Cognos Analytics

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

Hi João,

Which version do you use? You might want to check the level of Audit on your system. Make sure your logging level is Basic (audit enabled) or Minimal (audit is disabled). You shoud avoid to use Full or Trace.

More information: Setting up audit reporting

Best regards,

------------------------------
Patrick Neveu
Collaboration Betters The World (CBTW)
IBM Champion

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
------------------------------

Hi Patrick, we are on version 11.1.7-2106251648

Also all our settings are at minimum

------------------------------
João Alves

Original Message:
Sent: Fri June 21, 2024 04:51 AM
From: Patrick Neveu
Subject: IBM Cognos Analytics Slow

Hi João,

Which version do you use? You might want to check the level of Audit on your system. Make sure your logging level is Basic (audit enabled) or Minimal (audit is disabled). You shoud avoid to use Full or Trace.

More information: Setting up audit reporting

Best regards,

------------------------------
Patrick Neveu
Collaboration Betters The World (CBTW)
IBM Champion

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
------------------------------

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

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

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

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

Hi Joao

Are you able to eliminate the webserver as a possible culprit by testing via the dispatcher directly?

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

When we upgraded to 11 (new Glass Interface) we had some issues with slow navigation when there were a lot of logged in users.  Increasing the value for "Maximum number of processes for the batch report service during peak period" resolved it.

Shawn

Hi Joao

Are you able to eliminate the webserver as a possible culprit by testing via the dispatcher directly?

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

Our setting is at 2, what value did you increase it to?

When we upgraded to 11 (new Glass Interface) we had some issues with slow navigation when there were a lot of logged in users.  Increasing the value for "Maximum number of processes for the batch report service during peak period" resolved it.

Shawn

Hi Joao

Are you able to eliminate the webserver as a possible culprit by testing via the dispatcher directly?

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