Scenario: A DBA notices a significant decrease in database performance during peak hours. What steps can they take to identify and resolve the bottleneck?

Option 3, tuning database configuration parameters, involves adjusting settings such as buffer pool size, lock timeout, and memory allocation to optimize database performance. This step can help address issues such as inefficient resource utilization or contention, which may be causing the performance bottleneck during peak hours. Monitoring system resources (option 2) and optimizing indexing strategy (option 4) are important steps but may not directly address configuration issues leading to performance degradation. Analyzing query execution plans (option 1) is helpful for identifying specific queries causing performance issues but may not resolve underlying configuration problems.