Bad Performance on Sybase ASE

[Private_Member_19084]

Hi experts,

we are planning to doing a migration from Oracle to Sybase ASE.

At the moment we are having one productive ERP System on Oracle and one testing system on sybase ASE.

If I do an select on the same table in Q and P, I have a big time difference.

Which means, in Q-System it is very slow.

At the moment I am trying to analyze the sybase, what is causig this problem.

Can some provide me some tips.

At the moment I am fighting with ST12.

If I make an explain in ST12, I get the message "No matching plan cound be found in the procedure cache - use Runtime Explain".

What does it mean or were can I check the execution plan for sybase ASE?

Thank you

[janos_czettler]

Hi Christian,

we have faced with similar problem with more sybase ase, with different sp levels. Usually system function which reading tadir, reposrc, eg. activation ddic elements, smartforms, etc...

finally I found a note:

1889090 - SYB: Activating smartform is taking too much time - TRDIR

This note said use "sp_recompile <tablename>" for use a new query plan for the select.

Try this workaround, or use the latest ASE patch level - as said the note.

Regards,

Janos

[Former Member]

Hi,

Why don't you try to run update statistics for all ERP tables in ASE...

that's my recommendation.

Regards,

sang-wook

[janos_czettler]

Hi Sang-Wook,

the ATM is configured from the beginning in or all ASE based ERP systems. So the automatic statistics update and the automatic table reorganization are running. There were not other database relevant performantce problems in the systems. Only when we activate a eg. function modul, smartform, or other DDIC objects... just during the system reading the table tadir (reposrc).

...until when we applied the workaround from note 1889090.

Regards,

Janos