how to add counters to the server performance monitor

Hi,
I am working on sql server 2000.
How to add counters to the performance monitor counter
list? What I mean is that you go to start-program-
administrative tools- performance. Then you right click
on the empty space in the graph pane, pick 'add counters',
a list of counter will show up,
including 'processor', 'physical disk', 'sql server-
general', etc.. On one of my server, all sql counters are
not in the list. how to add more counts into the list
(activate those counters)?
Many thanks.
JJJJ
Sometimes, for a wide variety of different reasons, the
SQL Server Performance Monitor counters will not show up
as they should. Often, but not always, this problem can be
fixed by following these three steps:
1) At the command prompt, type in the following:
unlodctr.exe MSSQLServer
2) Then type in the following: lodctr.exe <SQL Server
path>\binn\sqlctr.ini
3) Reboot the server
Hope this helps
John|||thank you so much, John. Sorry for couldn't response to
you earlier. Been really busy lately.
I don't know whether this is something safe to do because
sometimes certain counter got disabled by the system
automatically because they have errors in them. If re-
active them, may cause problem to the server or slow the
system down.
I could very well be wrong at this. Just want to make
sure with you first.
Please see below quoted from window's help article:
----
Cause: Test routines that run when you start Performance
have detected a problem with installed counters and have
disabled the counters automatically to prevent the
counters from slowing the system. Disabled objects and
counters do not appear in the Add Counters dialog box.
Solution: Using Registry Editor, change the value under
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Servic
e_name\Performance\Disable Performance Counters from 1 for
disable to 0 for enable. Note that counters that have been
disabled after initial testing are likely to contain
errors and may cause system problems. For information
about debugging problems with counter DLLs, see the
Microsoft Web site (http://msdn.microsoft.com/).
Caution
. Incorrectly editing the registry may severely
damage your system. Before making changes to the registry,
you should back up any valued data on the computer.
----
Thanks.
JJ
>--Original Message--
>JJ
>Sometimes, for a wide variety of different reasons, the
>SQL Server Performance Monitor counters will not show up
>as they should. Often, but not always, this problem can
be
>fixed by following these three steps:
>1) At the command prompt, type in the following:
>unlodctr.exe MSSQLServer
>2) Then type in the following: lodctr.exe <SQL Server
>path>\binn\sqlctr.ini
>3) Reboot the server
>Hope this helps
>John
>.
>