Skip to Content
author's profile photo
Former Member

Information Broadcasting

Dear All,

I have a dashboard which has atleast 24 queries. I wanted to optimise the dashboard by caching the queries.

I have the caching setup using RSRT across all the application servers.

Now, I wanted to schedule filling the OLAP cache and I used Info Broadcasting.

I scheduled all my broadcasting jobs to run at 6AM in the morning. But this brings down the server. I get no errors and/or cancelled jobs but the server0 goes down.

Is there a limit on the number of braodcasting jobs I can schedule in parallel? Or if so what is the best practice.

Thanks in advance!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Sep 24, 2007 at 09:22 PM

    Karan,

    Is there any info in System Log (SM21 or SM22) about the likely cause (memory, work process, ...) of server going down? If it is a hardware limit, likely you will have to stagger it (like few queries at a time).

    cheers,

    Add comment
    10|10000 characters needed characters exceeded