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?
JR110Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.