performence issues in data loading

[Former Member]

Hi All:

I am new to SAP-BW please could anybody tell me how to improve (what are all the steps) in data loading or performence consideration in back-end.

I will appreciate for your input.

Thanks in Advance.

Regards,

ASHOK

[Former Member]

Ashok,

There is a very good document on SDN on performance,

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/afbad390-0201-0010-daa4-9ef...

Also if you login to the service marketplace and go to the bi infoindex.

http://service.sap.com/bi

there is a performance area where you can download information etc.

One of the best tips I have found that most of these documents will outline in more detail is to buffer the SID Number range objects accessed in table NRIV. Once you find the NRO's that are causing a great deal of reads on the NRIV table you can navigate to transaction SNRO and identify the iobj NRO BIM* to be buffered enter it into the input field and hit change. From the edit menu select Set-Up buffering. From here you can configure the buffering of your iobj SID NRO's.

Of course before going through this process do an SQL trace during the load process to identify whether or not the NRIV table is causing performance issues.

I hope this helps.

Cheers,

Scott