Powered by Zoomin Software. For more details please contactZoomin

DataDirect Connect for ADO.NET Data Provider Help

PerfMon Support

  • Last Updated: April 16, 2026
  • 2 minute read
    • ADO.NET
    • Documentation

The Performance Monitor (PerfMon) utility allows you to record application parameters and review the results as a report or graph. You can also use Performance Monitor to identify the number and frequency of CLR exceptions in your applications. In addition, you can fine-tune network load by analyzing the number of connections and connection pools being used.

All DataDirect Connect for ADO.NET data providers install a set of PerfMon counters that let you tune and debug applications that use the data provider. The data provider’s counters are located in the Performance Monitor under a category name, for example, DataDirect Oracle ADO.NET Data Provider.

The following table describes the counters that you can use to tune connections for your application.

PerfMon Counters

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.
If the Max Pool Size Behavior connection string option is set to SoftCap, the value returned can be greater than the value defined for the Max Pool Size connection string option.
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.
Total # of Failed Commands Returns the total number of command executions that failed for any reason since the process started.

For information on using PerfMon and performance counters, refer to the Microsoft documentation library.

TitleResults for “How to create a CRG?”Also Available inAlert