During the load test, we should monitor the following key metrics:
- Query Performance: Latency and throughput. - System Resources: CPU and memory utilization, disk I/O, and cache efficiency. - Database Activity: Active connections and locking/blocking behavior. - Logs: Any errors or anomalies observed.
Additionally, we will need to compare the baseline performance with the load test results to identify potential bottlenecks and areas for optimization.
