BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Issue in performance

Search this topic... | Search DI: Performance and Tuning... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Author Message
Forum Member
Forum Member

Joined: 01 Mar 2006

Posts: 24

PostPosted: Fri Mar 10, 2006 5:48 pm 
Post subject: Issue in performance

We are migrating from one network to another network. So we have installed BODI server on a new box now. We have imported the whole repositories. Now when we are running job its taking very long time. It was working fine before this. We had issues in network where packet was getting dropped but it has been fixed.

If I try a job where target is table then it is taking time. where as if i make targt one csv file and in next data flow i load from csv to table without any transformation then it is taking very less time.

If i make xml file as target with schema so that in next step i can use it as source ... it is taking very long time.

The initiatiation process of a job is also taking longer time compared to last server. Can anyone tell me where I need to look for finding out the issue ??

Is there any parameter which u need to set which improves performance as the whole code is same as we used export and import ??

RAM of that machine is 4gb.

Any help on this is appreciated..... If you need any more info then please let me know..
Back to top
Principal Member
Principal Member

Joined: 06 Oct 2005

Posts: 233
Location: Chicago

PostPosted: Tue Mar 21, 2006 4:38 pm 
Post subject: Re: Issue in performance

I would try something like keep a rowgeneration and load 10 million records to target table/xml/text file/Reject all using map operation and see whats happening in each case.

Hope this helps
Back to top
Forum Enthusiast
Forum Enthusiast

Joined: 16 Sep 2005
Posts: 1815
Location: Orlando, FL

PostPosted: Wed Mar 22, 2006 7:48 am 
Post subject: Re: Issue in performance

If the only thing that is changed is the network and physical box (ie, you did not use a different version of DI, you are going to the same DB type and from the same type source, etc), then I would look at the things that changed. Is the network bandwidth the same on the new network between the source and target? Is the box equivalent or better than the original system (RAM size, RAM speed, disk speed, number of CPU's, speed of CPU's, etc)? Are you using the same network protocol? Have you done end to end ping tests on both network setups and are they equivalent?

- Ernie
Back to top
Forum Member
Forum Member

Joined: 11 Mar 2006

Posts: 3

PostPosted: Sun Mar 26, 2006 5:09 pm 
Post subject: Re: Issue in performance

I agree with the previous posts. To diagnose the problem you have to determine whether the issue is with the new box, database that DI is running on etc... To diagnose the new box I might suggest loking at the stats in task manager, see if there is any effect on memory, cpu usage etc... As for the databases you may need to use a profiling tool to determing what exactly is happening at a database level. Good luck.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0427 seconds using 17 queries. (SQL 0.0169 Parse 0.0009 Other 0.0249)
CCBot/2.0 (
Hosted by | Terms of Service
phpBB Customizations by the
Shameless plug for Moments of Light Logo