MSSQLCity.Com - All about MS SQL
     
About Us  
SSWUG Articles  
Articles  
FAQ  
Administration  
Backup/Restore  
Connectivity  
Development  
General  
Installation  
OLAP  
Replication  
Transfer/move  
Trouble  
SQL 6.5  
Scripts  
Tips  
Test Exams  
Advertise  
Download  
History  
Search  
Traffic  
Related Links  
     
Your button logo
Add to Favorites
 
     
 


Why cannot I see the SQL performance counters in PerfMon?

Answer:

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:

unlodctr.exe MSSQLServer
C:\WINNT\System32\lodctr.exe "c:\mssql7\BINN\sqlctr.ini"

but MS SQL 7.0 counters did not appeared.

After that I checked this key in the registry

HKEY_LOCAL_MACHINE\Software\Microsoft\WindowsNT\CurrentVersion\Perflib

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:

unlodctr.exe MSSQLServer
C:\WINNT\System32\lodctr.exe "c:\mssql7\BINN\sqlctr.ini"

and now everything is okay.

Check this link also:
http://support.microsoft.com/support/kb/articles/Q196/6/57.ASP


 

 
Visit The SQL Server Worldwide User's Group for all the latest news and information about SQL Server, Oracle, DB2 and XML for developers and administrators.

(c) 1997, 2010 Bits on the Wire, Inc