Performance tuning EA <-> Oracle Repository

[Andreas1975]

Hi all.

Is there any tips & tricks of tuning EA (client, network, database) when working against a rdbms repository?
(Except the wan optimizer ofc)

The EA users feels the tool is way too slow due to the repository.

Tuning the EA client itself, network or the database - All tips & tricks are mostly welcome, since I today have no idea where the bottlenecks are.

Running EA 10.0 with an Oracle 11 on the LAN.

Running: Oracle Provider for OLE DB, Connection String:
UC_OEREA_PRD --- DBType=3;Connect=Provider=OraOLEDB.Oracle.1;Password=xxxxx;Persist Security Info=True;User ID=UC_OEREA_PRD;Data Source=EADB12;LazyLoad=1;

Thanks
Regards
Andreas

[OpenIT Solutions]

A few things to consider with poor performance.

- its unlikely to be the database itself, more likely to be the network - are you on a WAN ? Global user base ? If the answer is yes, then try as you mention the WAN Optimizer. If this doesn't work, consider a citrix type/based solution with the server co-located with the database.
- turn off Sparx auditing - this kills the database.
- Be aware that large XMI import/exports will impact other users, so schedule them for downtimes. Same to a much lesser extent with html portal generation.

Also be aware that lts of users complain about performance simply because what they really want is to be left alone to carry on using visio ! They just need slapping :-).

Regards,

Jon.

[Geert Bellekens]

IIRC there were recently some issues with Oracle performance that have been fixed.
Try searching the release notes.

Geert

[Andreas1975]

Also be aware that lts of users complain about performance simply because what they really want is to be left alone to carry on using visio ! They just need slapping :-).

This one is spot on for me.... But I seriously need to limit their arguments for continuing with visio...

Geert - I found thoose issues, but they was related to the EA Client, and we are using the latest one.

Everything seems to point towards moving the repository closer to the office. It's a highspeed network, but 500km to the repository surely affects performance at least a bit.

regards
Andreas

[OpenIT Solutions]

We ran a few tests to find out where our issues where :

- tracert <oracle server name>

To get a feel for the network latency / hops involved. You network team should be able to dig deeper. I saw something in the WAN Optimizer docs that gives some figures re acceptable/average latency.

We got both our DBA and Sys Admin teams to monitor the load on our database server.

What we found was that the issue was as i mentioned nextwork latency, however we had the server in London and some clients in Singapore...its these clients that were experiencing poor performance. On an average WAN 500K really shouldn't pose that much of a latency issue.