SAP BODS Designer performance issue

[Former Member]

Hello experts ,

We are having a peformance issue when the developers are working on the Designer.

Just to save any changes takes bout 15 minutes.

importing a small filel (90 KB) takes another 2 minutes

e configuration is the following one:

- BODS 4.2 SP2 is installed on Linux SUSE

- DB is Oracle 11g R2

Designer version that is being used is SAP BODS Designer SP02 patch2

Higly appreciate for any  suggestions

[former_member187605]

Are you running over a WAN? DS Designer is a client-server tool with numerous roundtrips to the underlying repositor database both at start-up and during design operations. It doesn’t work properly in a WAN environment due to network latency. That’s why I always recommendat the instalation of a WTS or similar, located in the same network segment as the DS server. You will work much faster thru a Remode Desktop Connection and will save time and effort in client installs and upgrades.

[Former Member]

Thanks Dirk,

Thats where we are leaning towards. But is there any SAP Note , any SAP refference , any official SAP reply that mentions "DS designer performance issue due to network latency due to WAN environment"

[former_member187605]

You won't get anything more official than what I've just told you. Anyway, what difference would that make?

This is not DS Designer specific. Any client server tool, accesssing a remote db over a WAN will suffer from the same issue.

The Citrix / WTS solutions are fully documented in the official DS Installation Guide.

[Former Member]

Hello Arjun

On the server it takes less than a  minutes which is how it's suppose to be

Regards

Basit

[former_member208363]

Hi Basit,

We are almost fixed the issue.

Please disable anti-virus completely.

Delete Temp files and unnecessary files which consumes the space.

[former_member208363]

Please provide the following info:

Check if any anti virus is running?

What is the RAM size of machine?

Did you get the same error in UAT/PROD?

[Former Member]

Hello Arjun

-  I have stop the Anti Virus. it is not running for the folders where SAP BODS client is installed

-  I have 4 GB of RAM in my workstation

-  At this point of time , we have only one environment.

Regards

Basit

[former_member208363]

Hi Basit,

Two more question, Did you try on server machine?

Did you try with Administrator Account?