Tuesday, February 4, 2014

IBM Cognos Reports Performance tuning Scenarios

S No 1. Report is on production environment previously it was taking 5 seconds to execute, suddenly it increased to 10 minutes. What immediate action to be taken to resolve this issue ?

 Ans:  If it is slow before selecting the prompt then it is report side issue OR If it is taking after selecting the prompt then db side issue. 

  •  "Execution Method" of the query objects in Cognos could be set to "concurrent", Concurrent query execution may improve performance in some cases.

  • Use Local Cache

    Specifies whether a query is a candidate for query reuse. If set to Yes, the query engine can reuse an existing SQL result. This property applies only to relational and dimensionally-modeled relational (DMR) data sources.

 

 




Posted by at
Labels:

5 comments:

  1. UnknownJanuary 23, 2015 at 5:27 AM

    It was very nice article and it is very useful to Cognos learners.We also provide Cub training software online training.

    ReplyDelete
  2. UnknownAugust 23, 2016 at 12:31 AM

    instructional blog about IBM Cognos Reports Performance tuning Scenarios. the way of explanation is very good. Online COGNOS Training Classes

    ReplyDelete
  3. SowmiyaSeptember 21, 2016 at 10:09 PM

    your blog is very much useful and thus i like more information from your blog it is very well and awesome. your instructions and notes are really super.

    Cognos Training in Chennai

    ReplyDelete
  4. UnknownNovember 4, 2016 at 2:45 AM

    Great article...
    uml training in chennai

    ReplyDelete
  5. veera cynixitJuly 29, 2020 at 2:01 AM

    very nice post,keep sharing more posts with us.

    thank you...
    cognos training

    ReplyDelete

Subscribe to: Post Comments (Atom)