perfmon counters missing

[JJ Wang]

Hi,

I am working on sql server 2000 with windows 2000 advance
server.

1. 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)?

2. how can I see the status of each counter on a certain
server that whether they are on or off. I assume the ones
missing from the counter list are the ones never got
turned on?

Many thanks.
JJ

 

[Dave Patrick]

You can Add/Remove them by regedit, but it's much easier to use exctrlst.exe
(Extensible Counter Listing Tool) from the
resource kit to enable/ disable the counters.

http://www.microsoft.com/windows2000/techinfo/reskit/tools/existing/exctrlst-o.asp


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft MVP [Windows NT/2000 Operating Systems]

 

[JJ Wang]

Great tip, Dave. I will read the readme files of each
tool and will keep you posted.

Thanks!!

JJ

-----Original Message-----
You can Add/Remove them by regedit, but it's much easier to use exctrlst.exe
(Extensible Counter Listing Tool) from the
resource kit to enable/ disable the counters.

http://www.microsoft.com/windows2000/techinfo/reskit/tools /existing/exctrlst-o.asp


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft MVP [Windows NT/2000 Operating Systems]

Hi,

I am working on sql server 2000 with windows 2000 advance
server.

1. 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)?

2. how can I see the status of each counter on a certain
server that whether they are on or off. I assume the ones
missing from the counter list are the ones never got
turned on?

Many thanks.
JJ

.