Analyzing Performance Benchmark Results
The output from performance benchmarks is statistics
that include query response times and resource utilization usage
for CPU, RAM, and other resources. When analyzing logs, the goal
is to detect bottlenecks, which can exist at different levels, including:
Application Level. Developers can look for inefficiencies
in their code.
Database Level. Use query optimizers and database profilers
to check for bottlenecks.
Operating System Level. Administrators can use utilities
tools, such as PerfMon on Windows and on UNIX top, vmstat, and iostat
to track CPU, RAM, and disk space utilization.
Network Level. Network Administrators can use utilities,
such as netstat and packet sniffers, such as tcpdump, and others,
such as ethereal.