«

I would like to save performance information using perfmon.exe using
the CounterLogs functionality. I am currently running a clustered
SQL2000 SP4 machine running on Windows 2003 Advanced x64. When starting
perfmon.exe I noticed that the SQL counters are not available, after
some messing around I found another copy of perfmon.exe in
C:\WINDOWS\SysWOW64\perfmon.exe.

If I start this executable I can now see the SQL Server performance
counters. And can interactively watch performance. The problem arises
when I attempt to create a CounterLog. I can create the counter log and
add the SQLServer counters but it does not log the SQLCounters.

Looking in the event log I get the following messages

The service was unable to add the counter '\\BEDB3\SQLServer:General
Statistics\User Connections' to the test log or alert. This log or
alert will continue, but data for that counter will not be collected.
The error returned is: The specified object is not found on the system.

Anyone know how to get this working?

Bert

anyideas?

I'd suggest asking over on the SQL Server sections of the newsgroups. It's
clearly a bug, but I don't know enough about SQL Server to know if there's a
workaround. Someone there should.

--
Charlie.
http://msmvps.com/xperts64

wrote:
> anyideas?

Thanks Charlie,

I have also asked there but I guess not too many people using SQL2000
on x64, every one gearing up for SQL2005 I guess. I am betting that
this issuse might exist for any 32bit performance counters. Do you
know any other 32bit applications that have performance counters that I
can test this theory on?

Thanks
Bert

Sorry, Bert. Not really my area of expertise.

--
Charlie.
http://msmvps.com/xperts64

wrote:
> Thanks Charlie,
>
> I have also asked there but I guess not too many people using SQL2000
> on x64, every one gearing up for SQL2005 I guess. I am betting that
> this issuse might exist for any 32bit performance counters. Do you
> know any other 32bit applications that have performance counters that I
> can test this theory on?
>
> Thanks
> Bert