SQL Server Performance

Issues Logging SQL Server performance counters to

Discussion in 'Performance Tuning for DBAs' started by bertcord, Sep 14, 2005.

  1. bertcord New Member

    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:WINDOWSSysWOW64perfmon.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 '\BEDB3SQLServer:General StatisticsUser 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
  2. Luis Martin Moderator

    Using QA, run select * from sysperfinfo.
    If no empty, then check:
    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6506

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  3. satya Moderator

  4. bertcord New Member

    The counters are there. I can view them when monitoring interactively. The problem occurs when I attempt to log them.

    Yes when I run
    select * from sysperfinfo

    I see the counters, and the counters are available to select. This is more of a x64 bit problem. IS anyone else running x64 and can confirm the same behavior I am seeing?

    Bert
  5. satya Moderator

    Oops if its x64 problem, then I have no experience to offer any solution.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. johnson_ef Member

    what is this x64 problem? Anyone can help me to understand this?

    -Johnson
  7. bertcord New Member

    I cant get perfmon.exe to LOG SQL counters to COunterLog. Are yourunning x64?

    Bert
  8. satya Moderator

    Bert referring x64 to SQL Server 64 bit version, do you have such installation.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  9. bertcord New Member

    No, This is x64 not IA64. So I am running SQL2000 SP4. SO SQL is actually still 32bit running on 64 bit OS.

    Bert
  10. satya Moderator

    Oh thanks, I believe you might search under x64 newsgroups for any solution.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  11. bertcord New Member

    Left a post on x64 newsgroup...not to much activity.....

    I am a little suprised that nobody here is tracking performance of SQL Server on x64 and confirm the same issues I am having.

    Bert
  12. I'm having exactly the same problem and still coudn't find a solution.
    Anyone can help?

    thanks in advanced
  13. bertcord New Member

    You can use the following workaround for this issue.

    1) Stop the Performance Logs & Alerts service from services.msc
    2) Open up the registry editor (regedit.exe), browse down to HKLMSystemCurrentControlSetServicesSysmonlog.
    3) Change the ImagePath from the default value to %SystemRoot%syswow64smlogsvc.exe.( This would launch the 32-bit service on starting the Counter logs)
    4) Open the 32-bit Perfmon from Start - Run - %SystemRoot%syswow64perfmon.exe, & add the SQL counter objects to a Counter log.
    5) Set the various parameters of the Counter log, & start it to collect the data.
  14. Excellent work man, you gave me a great solution.!

    Thanks
  15. mckirdyp New Member

    +1, nicely done. I have set it up here and it works wonderfully. Another big, THANK YOU! <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />-Paul<br /><br />"as you think, so shall you be"
  16. mckirdyp New Member

    Just wanted to add:

    You can log to database as well by using the WOW64 ODBC drivers.

    Run C:WINDOWSSysWOW64odbcad32.exe to setup DSNs that can be used by the 32bit PerfMon to log to database as well.

    -Paul

    "as you think, so shall you be"

Share This Page