Hi all gurus
I am having a strange problem.
I am having a cluster box win 2000 Advance server running Sql server in
Active/Passive mode.
Currently we are having 250 + prod database on that box.I wanted to do some
Perf. Tuning on the box
But i cannot see any of the Sql related Performance Counters in PerfMon.

The CPU is shooting 100% all the time, disk I/0 are not that high.
I wanted to debug SQL Counters.
Any help is really appreciated.

This might explain some of it:
http://support.microsoft.com/default...&Product=sql2k

--
Andrew J. Kelly SQL MVP


"Nik" <patelnikhil30 (AT) hotmail (DOT) com> wrote

Thanks Andrew
I guess we are also running some kind ok Third Party tool to monitor the
servers in enterprise.
may be that may have caused the sql counters to be dropped.
I am seeing that Wait type and WaitTime is 0
thanks Again

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

http://support.microsoft.com:

Clustered SQL Server Do's, Don'ts and Basic Warnings [Q254321]

SQL Perf Counters Missing After MDAC Install on Cluster [Q246328]

"Event ID (1001) in Source (SQLCTR70) Could Not Be Found" [Q196657]

Missing Objects and Counters in Performance Monitor [Q127207]

SQL Performance Monitor Counters Missing [Q227662]


************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...