cancel
Showing results for 
Search instead for 
Did you mean: 

BODS designer open very very slow

Former Member
0 Kudos

Using BODS ver 14.1.1.210. Repository on Oracle 11g.

It was working fine until couple of days back. After i imported a whole lot of jobs (1200) the designer went ridiculously slow. It took probably more than an hour to come up. mad.gif

In the repository AL_LANG table, there are about 5500 entries. There does not seem to be any DB stats run on the table in a long time. Don't know if that would help.

How many jobs in the repo does the designer handle without significant slow down? What can be done to improve the performance?

Please advise...

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member200473
Contributor
0 Kudos

Hi Sreedhar,

1-Please use Compact Repository option into Local repository.( BODS version 3.2)

2- Please increase Pageable cache from Jobserver.

3- Please confirm you have sufficient hardware/network resources.

Please update the thread.

Regards,

Shiva Sahu

Former Member
0 Kudos

Checked AL_HISTORY AND AL_STATISTICS and had no issue with them.

Will check on applying the patch and let you know.

Thank you 🙂

Former Member
0 Kudos

Hello Sreedhar,

1) Tune your repository DB server.

2) Tune the network

3) Tune the OS

first try for DB server side..

Regards

Subbarao

md_fasi
Participant
0 Kudos

Hi Sreedhar,

Would like to know how often the BODS admin follow maintenance methodology.I would suggest to restart the appplication once at OS level and try again. Since it is backed by tomcat application(Java) servers.It might have some issues related to Heap size memory.

Try it and let us know the results.

Regards

Former Member
0 Kudos

Hi Rahman,

Is there is any documentation on the maintenance methodology you could direct to?

thanks

Former Member
0 Kudos

Hello Sreedhar,

Have a look at the reply given by ..

you will get  some help from them....

Former Member
0 Kudos

Hi,

Try to remove *.dmp files present in LOG directory of Installation path.

Regards,

Amar.

Former Member
0 Kudos

Amarnath,

I checked but did not find any .dmp files. I looked under D:\Program Files\Business Objects\Data Services folder and its sub-folders. May be they are on the job server somewhere. I have to check with the admin.

thanks

Former Member
0 Kudos

Hi,

We had same problem.

1. Check Network latency

2. Check CPU Usage and which process consume more memory You will get some idea

Regards,

Manoj.

Former Member
0 Kudos

Don't think any network latency. After designer is up it works fine.

Most of the resources are consumed by AL_Designer.exe.

CPU usage - 25 (keeps bouncing 24-26)

Memory - 609,224 K