Issues Logging SQL Server performance counters to counter log

Discussion in 'Windows 64bit' started by bertcord@gmail.com, Sep 16, 2005.

  1. Guest

    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
    , Sep 16, 2005
    #1
    1. Advertising

  2. Guest

    anyideas?
    , Sep 21, 2005
    #2
    1. Advertising

  3. 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?
    Charlie Russel - MVP, Sep 21, 2005
    #3
  4. Guest

    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
    , Sep 25, 2005
    #4
  5. 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
    Charlie Russel - MVP, Sep 25, 2005
    #5
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Brian Whiting
    Replies:
    2
    Views:
    679
    Brian Whiting
    Dec 29, 2005
  2. Cyrus Bharda
    Replies:
    5
    Views:
    10,755
    Cyrus Bharda
    Jul 9, 2003
  3. =?Utf-8?B?QnJlbnQgTWlsbHM=?=

    Performance Counters

    =?Utf-8?B?QnJlbnQgTWlsbHM=?=, Jul 1, 2005, in forum: Windows 64bit
    Replies:
    7
    Views:
    497
    Andre Da Costa [Extended64]
    Jul 2, 2005
  4. =?Utf-8?B?Um9kcmlnbw==?=

    SQL Server 2000 Performance Monitors in Windows 2003 x64

    =?Utf-8?B?Um9kcmlnbw==?=, Aug 2, 2006, in forum: Windows 64bit
    Replies:
    3
    Views:
    484
    Colin Barnhorst
    Aug 2, 2006
  5. Replies:
    0
    Views:
    1,420
Loading...

Share This Page