CompTIA Network+ N10-009 Practice Question
During an analysis of network traffic patterns, a network administrator detects intermittent latency spikes that are not associated with scheduled backup operations. These spikes coincide with high utilization rates on the database server. Which of the following methods will most effectively further analyze the nature of the traffic causing these spikes?
Review firewall logs for denied connections during the times of spikes
Implement port mirroring to capture the traffic to and from the database server
Set a new Quality of Service (QoS) policy for database-related traffic
Optimize database queries to reduce load on the server