cause of performance problem on ASE production server

[holdahl]

We have a seriuous performance problem with one of our ASE production servers.
On some weekdays lately between 8pm and 10pm something is causing the server to use all resources.
Is it possible to find out what might cause this..
application, procedure, job or something else?
The use of mda tables and continuously extract data from the MDA history tables and store it in a permanent table. Is it possible to identify these kind of things through the MDA tables?

-holdahl

 

[SantaMufasa]

Holdahl,

Did you resolve this issue?

If so, please post your resolution/workaround.

If not, please reply so that contributors can post suggestions.

Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]