| || |
Monitoring Database server
Once we get the database server result from the controller and genrate the graph. how to analyze the database server graph.
measurement counters like -
data collected from the V$ tables . SQL*Net statistics – active users, active sessions, average response time o Background processes – Redo log writer, DBMS writer, archiver o SGA – Buffer cache utilization and hit ratio, keep and recycle pool usage, redo buffer usage, shared pool usage, sorts o I/O - Redo log statistics, I/O events, wait events, object and file growth, locks, latches o Log - alert logs messages,Execute Queue, Http Keep-Alive, pid.value, handle.avg.
Thanks for reply in advance.
Re: Monitoring Database server
Sit down with your Database Administrator and discuss these measurements. He should be able to tell you wich measurements are interesting to watch and he should also be able to analyze them.
You can't expect a performance engineer to understand all counters for all infrastructure components. Use the knowledge of the infrastructure guys for your specific situation.