Обсуждение: Monitoring performance

Поиск
Список
Период
Сортировка

Monitoring performance

От
Jan Ploski
Дата:
Hello,

Is there a way to monitor query performance on the database server level?
What I am doing now is tweaking the JDBC driver to log slow queries
(slow = taking longer than some arbitrary threshold), but it appears to
me that the db server itself should be the ideal place for such tasks.

Can anyone point me to some documentation about how to get to some
internal stats, if they exist? I have found nothing in the Admin guide
nor in the book (apart from general advice about top/ps).

Thanks,
JPL