Why cannot I see the SQL performance counters in PerfMon?
It's interesting problem. I checked sql counters on the work and everything
was okay. But when I checked it on my home computer (Windows NT Workstation,
MS SQL 6.5 and MS SQL 7.0) I found that native Windows NT perfmon counters
were not shown, and MS SQL 7.0 SQL performance counters were not shown too.
After that I tried to run this bat file:
but MS SQL 7.0 counters did not appeared.
After that I checked this key in the registry
and saw that it included two subkeys: 009 and 019.
019 - it is my native regional settings, 009 - U.S. English.
After that I deleted from c:\winnt\system32 (path for my Windows NT
installation) two files: perfc019.dat and perfh019.dat.
Now I can see native Windows NT counters, but MS SQL 7.0 counters
were not still visible.
After that I run this bat file again:
and now everything is okay.
Check this link also: