|
 |
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 | |
|
||
|
|
||
 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 |