[CSHARP-894] Add windows performance counters for connection pool status Created: 19/Jan/14  Updated: 18/Aug/14  Resolved: 18/Aug/14

Status: Closed
Project: C# Driver
Component/s: Connectivity
Affects Version/s: None
Fix Version/s: 2.0

Type: New Feature Priority: Minor - P4
Reporter: Jose Luis Pedrosa Assignee: Unassigned
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

any


Epic Link: Adopt Core Library

 Description   

Performance counters should be added to allow for enterprises to track usage of connection pools and connections.

The performance counters we are planning on supporting are:

  1. AverageConnectionLifeTime
  2. AverageSizeOfReceivedMessagesInBytes
  3. AverageSizeOfSentMessagesInBytes
  4. ConnectionPoolUtilizationPercentage
  5. CurrentNumberOfActiveConnections
  6. CurrentNumberOfAvailableConnections
  7. CurrentNumberOfOpenConnectionPools
  8. CurrentNumberOfOpenConnections
  9. CurrentWaitQueueSize
  10. NumberOfConnectionsCheckedInPerSecond
  11. NumberOfConnectionsCheckedOutPerSecond
  12. NumberOfBytesReceivedPerSecond
  13. NumberOfBytesSentPerSecond
  14. NumberOfMessagesReceivedPerSecond
  15. NumberOfMessagesSentPerSecond


 Comments   
Comment by Craig Wilson [ 20/Jan/14 ]

In the currently implemented feature set, the user isn't in control of connection lifetime (as in, they don't need to dispose of the connections themselves). Therefore, if there is a leak, it's everyone's problem and it would be our fault. Hence, no need for this particular counter. However, as we are refactoring even more, this idea might switch and, if it does, then we would definitely need to implement this one to allow user's to see if they are leaking.

Thanks for the help.

Comment by Jose Luis Pedrosa [ 20/Jan/14 ]

Hi Craig,

The only one I'm missing and maybe It's related to a functionality that it's not implemented is : "NumberOfReclaimedConnections". This can be useful to detect if there's any leak.

Thanks for your fast answer. I Did not check that branch when I had a look.

Rgds

JL

Comment by Craig Wilson [ 20/Jan/14 ]

Hi Jose,
We are planning on having this functionality in our next major release. It's actually already coded up and the list of perf counters we are currently using is here. I'm going to use this ticket as the feature tracking and alter the description to include the list of performance counters we should export. If there are any others you would like to see, please leave a comment or alter the ticket description.

Craig

Generated at Wed Feb 07 21:38:07 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.