skip to main content
Developing ADO.NET Applications : Diagnostic Support : PerfMon Support
 

PerfMon Support

The Performance Monitor (PerfMon) utility in the Windows operating system 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.
The .NET Client installs a set of PerfMon counters that let you tune and debug applications that use the data provider. The .NET Client’s counters are located in the Performance Monitor under a category name, for example, OpenAccess .NET Data Provider.
The following table describes the counters that you can use to tune connections for your application.
 
Table 38: 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.
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.