Performance problem: how to detect which query ? 2007-05-14 - By ilacosta@(protected)
Back
Hello,
We have a MaxDB 7.6, starting from 7.4, in web application environment
since years with minor problems, but now, with the same level of activity
we have a serious perfomance problem, that is causing loss of service.
We are running dbanalyzer, but the warnings shown are not critical.
Statistics are up to date and all indexes are enabled and none of them are
bad.
I would appreciate some help to detect where is the problem or some hints
to isolate what queries are the most expensive.
Thank you very much.
Best regards,
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---
Ignacio Lacosta
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---
|
|
