• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 363
  • Last Modified:

Need Help setting up Perfmon on SQL server NT4, sp5

When I set up the sql server 7.0 on nt 4 server, under nt service pack 5 and sql service pack 1 I do not see the sql options under perfmon.  Is it because I installed nt service pack 5 last?
0
JR110
Asked:
JR110
  • 2
  • 2
1 Solution
 
chigrikCommented:
Read about
"I can't see the SQL performance counters in PerfMon. What could be wrong?"
http://www.ntfaq.com/ntfaq/sql275.html#sql275

Look also at here:
http://support.microsoft.com/support/kb/articles/Q228/8/04.ASP

Hope this helps.
0
 
JR110Author Commented:
I'm using sql7.. and I tried your advice for sql7, unloading and loading the counters did not work.

J!
0
 
chigrikCommented:
It's interesting problem. I checked present of sql counters on the work and all was ok. But when I checked it on my home computer (Windows NT Workstation, MS SQL 6.5 and MS SQL 7.0) I has found out that native Windows NT perfmon counters are not shown and when I switched on MS SQL 6.5 I saw only SQL counters and when I switched on MS SQL 7.0 I saw nothing (the empty list).

After that I tried to run this bat file:

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

but MS SQL 7.0 counters are not shown.

After that I saw on 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 (more exactly removed this files on another path, where NT can't find it). Now I have seen 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 "f:\mssql7\BINN\sqlctr.ini"

and now all ok.

I suspect that your problems are connected to installation sp5 for NT. What about regional settings? May be you can't see native Windows NT counters also? And last question: Are you start MSSQLServer service before checking presence sql counters (excuse me for this question)?

Look also at here:
http://support.microsoft.com/support/kb/articles/Q196/6/57.ASP

It really helped me, I hope it will help you too.
0
 
JR110Author Commented:
Thanks, chigrik,

This worked, although I had to change directories to the c:\mssql7\binn
directory before the counters would load properly.  They would not load by specifying a remote path.

Thanks, Take Care, J!
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now