IBM WebSphere Application Server Network Deployment V8.5 and V9.0, Core Administration — Question 16

What information must the system administrator have to successfully tune a connection pool?

Answer options

• A. The requests per second that occur during a peak.
• B. The MaxConnections and WaitingCount values.
• C. The number of concurrent requests waiting for a connection.
• D. How long the database takes to respond to SELECT operations only.

Correct answer: D

Explanation

The correct answer is D because understanding the response time for SELECT operations is crucial for tuning the connection pool to handle load efficiently. Options A, B, and C provide useful information but do not directly address the primary factor of response time that impacts connection pool performance.