What information must the system administrator have to successfully tune a connection pool?
What information must the system administrator have to successfully tune a connection pool?
To successfully tune a connection pool, the system administrator needs specific information about the connection pool's performance characteristics. The MaxConnections and WaitingCount values are crucial as they directly indicate the pool's capacity and current demand. MaxConnections show the maximum number of connections that can be created, while WaitingCount reveals how many requests are queued waiting for a connection, allowing the administrator to adjust the pool size accordingly and improve efficiency.
I think that correct is A. Event in the reference's presentation there is a statment: In order to successfully tune the connection pool, you need to know two pieces of information: The requests per second that occur during a peak How long the database takes to respond to each type of operation SELECT, INSERT, UPDATE, and so on So it's not only SELECT operation but all database operations.