Missing perfmon SQL objects

I'm having an issue with a SQL 2000 cluster. On each node, there always
seems to be only one instance of perfmon SQL objects available at a time.
There are 3 instances of SQL installed on the cluster, default, PROD0 and
PROD1. On each physical node, opening perfmon to set up counters, there is
always only one set of SQL objects available. for example, as I write this,
only the default instance counters are available (SQLServer:<objectname>) on
the active node, but on the passive node, only the MSSQL$PROD0 objects are
available.
Any ideas?
Hello dwaine,
I understand that you could not see the performance counter in a SQL 2000
cluster environment.
You may use the following steps:
To get the counters loaded, SQL Server was taken offline and perfmon was
closed on the active node.
Simple Network Management Protocol (SNMP) service and the antivirus
software service were both stopped.
The following files were copied to the C:\Program Files\Microsoft SQL
Server\MSSQL\Binn folder:
From the SQL Server 2000 setup files: sqlctr.h
From the SQL Server 2000 sp4 setup files: sqlctr.ini and sqlctr80.dll
The following commands were run from the command prompt in the Binn folder
of the SQL Server instance:
unlodctr MSSQLServer
lodctr.exe \\VirtualServerName sqlctr.ini
net helpmsg %errorlevel%
Then, you will see the counter.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.