BUG: Performance counters for SQL Server .NET Data Provider are not reset

Article translations Article translations
Article ID: 314429 - View products that this article applies to.
This article was previously published under Q314429
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page

SYMPTOMS

When you install the .NET Framework on a computer, a .NET CLR Data performance counter is added to Performance Monitor (Perfmon). If you use these counters, you may notice that the perfomance information is not reset when you close and then reopen a .NET application. You also may notice that the perfomance information is not reset when you browse a .NET CLR Data performance counter on a remote computer.

RESOLUTION

To reset the performance counters, you must quit the application and close Performance Monitor.

Note that there is a delay before the counters are reset. If you reopen Performance Monitor immediately, the counters may not yet be cleared. If you wait a minute or two, they will be reset.

STATUS

Microsoft has confirmed that this is a problem in the .NET CLR Data counters. Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to reproduce the behavior

  1. Write a .NET application that opens 10 SqlConnection objects.
  2. Start Performance Monitor, double-click Performance Logs and Alerts, and then double-click Counter Logs.
  3. Double-click System Overview, click Add, and then click .NET CLR Data in the Performance Object list.
  4. Click All counters to add all of the SqlClient counters, click Add, and then click OK.
  5. Run the application, and note that the number of connections that Performance Monitor shows is 10.
  6. Quit the application, and note that the number of connections that Performance Monitor shows is still 10.
  7. Run the application again. Note that the number of connections that Performance Monitor now shows is 20. The counter was not reset when the previous instance of the application was closed.

REFERENCES

For more information about performance counters, click the following article number to view the article in the Microsoft Knowledge Base:
216950 How to enable ODBC Connection Pooling performance counters

Properties

Article ID: 314429 - Last Review: February 27, 2014 - Revision: 6.3
APPLIES TO
  • Microsoft .NET Framework 1.1
  • Microsoft ADO.NET (included with the .NET Framework)
  • Microsoft ADO.NET 1.1
Keywords: 
kbnosurvey kbarchive kbnofix kbbug KB314429

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com