Skip to Content

How to reduce BI DB server and Application Server utilization

Hi BW Experts,

Frequently BI DB server and Application Server is reaching 100 %. I just want to know how to reduce the CPU Utilization for both the servers.

1. I have reduced the parallel jobs from Process chain

2. I have kept 4 as parallel processing in DTP level.

3. For DSO activation i have kept the parallel processing as 5.

4. Created Secondary indexes in the DSO Level.

What are the other actions we can perform for reducing BI DB server and Application server. Please suggest.

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on May 18, 2015 at 02:24 PM

    Hi Jalina,

    You have reduced the parallel jobs in Process chain, DTP, DSO activation and several places.

    But If you run many events on same time it will consume all your jobs available on Application server.

    You have to check which job is giving you problem or you have to find out timeslot when many jobs triggers. So you can optimize your server utilization

    Thanks,

    KD Jain

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.