We're having performance issues with our Cognos reports, and trying to isolate if it is a Cognos issue or a database issue. One thing I noticed was that java.exe is consuming 1.37 GB of memory on the server that runs Cognos reporting server. It also runs MS IIS 6 Web Server. The server has 16 GB total, and 10 GB is still available, so we aren't maxing out.
The server is Windows Server 2008 R2 Standard 64 bit. Cognos version is 10.1. Java version is 6.0.
Hi Tim,
This means you are not able to utilize complete resources of your servers.
Cognos 10.1 executes in a 32-bit execution mode even if you have 64-bit installation.
Coming to your performance issue, please generate the SQL and fire it Database and see how much time database is taking up. If database is taking more time you have to optimize either the database or query. If it works fine in Database, just see how much time it takes to get the tabular data and meanwhile monitor the system performance. If tabular data comes soon this means you cna still optimize your report or else it is an environment issue.
Regarding your environment, I would suggest you to do a distributed installation in the same machine to utilize your resources fully.
Regards,
Rahul
What about the 1.37 GB of memory which java.exe is using? Is that normal, or is it a concern?
It is normal.
I just checked my system while I was on it and your Java usage is inline with what is happening on my system (we actually use just a bit less). So like Rahul said, it is pretty normal.
Thanks Rahul and Danno!