Post reply

why cognos cubes run 30% faster after the server is rebooted?

  • November 20, 2008 at 8:22 am

    #127742

    this database server has sql 2005 on it, and it is rebooted every Friday. I noticed Cognos cubes run faster every time after rebooting. What could be the reason? Does that mean we have to reboot

    it everyday? Thanks.

  • November 20, 2008 at 9:40 am

    #901142

    check your memory settings, run a profiler trace. too many possibilities to think about

  • November 20, 2008 at 8:27 pm

    #901404

    this server has Win2003, SQL2005, 16g RAM, AWE enabled, min server memory = 0, max server memory = unlimited. how do I know how much memory is used by sql and how much is by Cognos while running Cognos cubes?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply