Tracking Connection Pool Performance in ADO.NET
All DataDirect Connect for ADO.NET data providers install a set of Performance Monitor (PerfMon) counters that return information that lets you tune your applications for performance.
The following table describes the PerfMon counters that you can use to tune pooling for your application.
|
PerfMon Counter |
Counter Description |
|---|---|
|
Current # of Connection Pools |
Returns the current number of pools associated with the process. |
|
Current # of Pooled Connections |
Returns the current number of connections in all pools associated with the process. |
|
Current # of Pooled and Non-Pooled Connections |
Returns the current number of pooled and non-pooled connections. |
|
Peak # of Pooled Connections |
Returns the highest number of connections in all connection pools since the process started. |
|
Total # of Failed Connects |
Returns the total number of attempts to open a connection that failed for any reason since the process started. |
Refer to the Microsoft .NET Framework documentation for information about using PerfMon counters.
