If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Performance Question - New Guy

Started by krypto69, 02 May 2013 12:05:02 PM

Previous topic - Next topic

krypto69

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?

blom0344

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