Skip to Content
author's profile photo Former Member
Former Member

database performance

Hi all,

iam planning to load init. data using LO. the data is appx. over 2 million for each data source(sales doc,billing).

So can any one guide me what are the performance issues or Precautions we need to consider in both sides(r3 and BW) before starting setup jobs and all, like table space, parallel running and etc...

iam initially looking in db02, but i did not understand any thing by that.

thanks in adv.

kiran

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2005 at 07:34 AM

    Kiran,

    first of all (probably you need some support of your basis team..), read OSS Notes

    416772 'General tablespace types, temporary tablespace' and 567745 'Composite note BW 3x performance DB-specific parameters'

    and 618868 'FAQ Oracle performance'

    Hope it helps!

    Bye,

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2005 at 08:05 AM

    Hi Kiran,

    Here are some:

    1.) Drop Indexes of the <b>CUBE</b> prior loading data to increase speed.

    2.) Ensure ample disk space is available in BW to house the incoming data.

    3.) Check if your network connection is stable enough and fast enough to handle lots of data from R/3 to BW.

    4.) It is preferred to run the extraction during hours that dont have users. Otherwise you might affect R/3 users and slow down the processing.

    5.) Run <b>SETUP</b> of tables in R/3 under the C<b>ENTRAL Instance</b>. It will fly!

    6.) If you can afford to have a mirror copy of R/3 and follow the "<i>How to Minimize Downtime PDF DOC</i>", you will extract data faster since you are the only user of the R/3 <i>mirror</i> copy.

    7.) Try to calibrate how many parallel task your BW Server can accomodate just enough to prevent locking issues...

    If helpful, pls grant points...

    Best Regards,

    --Jkyle

    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.