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?

Solution 1

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.

Solution 2

Note: the accepted answer does not appear to apply to Windows 7 x64.

It seems that on the newer platform, netfxperf.dll isn't a COM dll at all. Therefore, using regsvr32 on it isn't going to work. This can be verified using several techniques - checking the registry, running Dumpbin, using Dependency Walker among others.

For me, rebuilding my performance counters (lodctr /R) as described here and rebooting fixed the problem.

Comments

[MrGigu]

The op states that they're using Windows Server 2003, which is several versions removed and a totally different architecture to Windows 7 x64. So I'm not entirely sure your criticism is due, but it's noted nevertheless.

[killthrush]

Good call - I missed the tag on that one. Will edit my post accordingly.