SQL Server Performance

Missing performance counters X64 OS with SQL2000

Discussion in 'Performance Tuning for Hardware Configurations' started by Dennis Kuit, Jan 16, 2006.

  1. Dennis Kuit New Member

    Hi

    I am using Windows 2003 Server Standard Edition X64 SP1. On top of that I have SQL 2000 Server SP4. Its a plain vanilla installation. Still, I miss all the SQL counters.

    SQLCTR80.DLL is in C:program Files (x86)Microsoft SQL ServerMSSQLBinn.

    Is SQLCTR80.DLL working under X64 wow? Are the missing counters in X64 w. SQL200 an known issue?

    Kind regards,

    Dennis.
  2. Luis Martin Moderator

    Check:

    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6506


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


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



  3. satya Moderator

  4. Dennis Kuit New Member

    Hi,

    Thanks, I corrected original titel and subject, I forgot to state i applied SP1 on Windows 2003 Server, so thats covered. The clean install was: a clean Opteron dual SMP machine -> OS install W2k3 Server standard ed R1 X64, booted from CD -> w2k3se SP1 -> remaining OS updates from Windows Update -> SQL 2000 enterpise edition -> SQL 2000 SP4. This results in this problem. In an earlier installation I did SP3a as an intermediate step before SP4, same problem.
  5. satya Moderator

    I feel its best to contact MS PSS in this regard, as minimal help available about x64 on web.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. Dennis Kuit New Member

    Well, problem solved.

    In the logfile I overlooked Event ID 1021:

    Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a 64-bit environment. Contact the file vendor to obtain a 64-bit version. Alternatively, you can open the 32-bit extensible counter DLL by using the 32-bit version of Performance Monitor. To use this tool, open the Windows folder, open the Syswow64 folder, and then start Perfmon.exe.


    You should start C:WINDOWSSysWOW64Perfmon.exe, this is the 32-bit version, and all the counters are there.

    I renamed this perfom to perfmon32, with a shortcut to the desktop.

    Now I can finally monitor the SQL memory usage, a important healthparameter running under X64.
  7. satya Moderator

    Wow, thats a magic and glad to know the resolution. I appreciate your time to post feedback.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  8. FrankKalis Moderator

    Looks like a good candidate for a FAQ. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  9. satya Moderator

    Thats why submitted to Brad already [<img src='/community/emoticons/emotion-5.gif' alt=';)' />].<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
  10. FrankKalis Moderator

    [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  11. pchee373 New Member

    This helped me too. I love this forum!!
  12. But what about when you try to save the SQL 2000 counters to a file?
    This is running like a 64bits application so SQL counters are not saved.

    Anyone find a solution?
  13. mckirdyp New Member

    Same thing with saving to database as well. You can actually add the counters to a counter log in the 32 bit version. They show up in the 64 bit perf mon app as part of the counter log even. But the only counters that save to database are non-SQL Server counters.

    Do need a fix for this, if its out there.

    -Paul

    "as you think, so shall you be"
  14. mckirdyp New Member


    Just in case, from another forum:

    "bertcord
    86 Posts
    Posted - 08/07/2006 : 17:35:59
    --------------------------------------------------------------------------------

    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.
    "
    --------------------------------------
    "
    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