Missing SQL perfmon counters in 2003 Cluster -- sql server clustering

Ayad
1/5/2005 3:09:52 PM

Hi,

I have SQL2000 cluster on Windows 2003 (2 Active nodes and 1 passive), one
of the active server is missing the SQL performance counters, the weird
thing is, if I run Perfmon remotely connecting to this node, it will not
display any SQL Performance counters but if I login locally to the server
and run Perfmon, it will show the SQL performance counters.

Any idea why is this happening.

Thanks

Ayad

Geoff N. Hiten
1/5/2005 3:29:20 PM

Permissions.

Try running the performance monitoring service using a real domain account
rather than the Network Service account.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

[quoted text, click to view]

sql server clustering : Missing SQL perfmon counters in 2003 Cluster