database performance

[Former Member]

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

[Former Member]

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

[Former Member]

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