Aug 24, 2011
tom
No Comments

Performance Monitor can’t add counters from .NET data providers

Question

I’m trying to monitor my database connections with Performance Monitor, but for some reason I can no longer add the counters.

Every set of counters OTHER than the two .NET Data Providers (for Oracle and SQL Server) works fine.

This was working not 10 minutes ago, when it just stopped. I’ve tried rebooting the box, which made no difference.

An suggestions on how to figure out how to re-enable these?

Answer

Here’s the solution:

Open cmd and run these commands:

regsvr32 /u netfxperf.dll
regsvr32 netfxperf.dll

Note: It seems that if you’re running the profiler, and kill IIS without stopping it first, you get this problem.

Check more discussion of this question.

Related posts:

  1. How do I convert the perfmon counters in the Performance Monitor to something that can log those for me?
  2. Using perfmon, which counters should I pay particular attention to when debugging ASP.NET and SQL performance problems?
  3. Performance Monitor w/ SQL Server – how many counters is too many?
  4. IIS HTTPS Windows Performance Counters
  5. Hyper-V R2 Performance Counters

Leave a comment