Hi,
I'm new to Cognos and just stood up an Old Cognos 8.4.1. Report server.
I have noticed that the reports (all of them) are very very slow to render.
I took one report and captured the SQL, put into the tuning wizard and tuned the DB side. The report query now takes 17 seconds to return the records.
When I go to the Congos report and run it in Cognos (same variables) it takes two and half minutes! what the..?
Are there some global cognos server settings I change? Is this normal for Cognos?
The query performance itself is just part of the whole story. Depending on the report design, the Cognos server may need to a little or a lot additional work.
You can check the individual queries by running the tabular data. If this is quick enough, then the slowdown may be due to the structure of the report. There are lots of performance killers. Probably the biggest one is the complex pageset, as it often means firing the same query over and over again.
Running aggregates are also real killers, as these are handled by the C server
Another strategy is to take the report and start simplefying the design and monitoring performance (make sure to flush cache each time). Also check the main report proces: BIBusTKServerMain.exe. Does it start to inflate to huge values in memory (or even worse : inflate / deflate / inflate / deflate ..)
Even with simple reports, the report will take obviously more time than the query