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?
Set a new Quality of Service (QoS) policy for database-related traffic
Review firewall logs for denied connections during the times of spikes
Optimize database queries to reduce load on the server
Implement port mirroring to capture the traffic to and from the database server