SQL Server Performance

SQL Server Performance Counters Missing

Discussion in 'SQL Server Clustering' started by edgar_guerrero, Apr 28, 2003.

  1. edgar_guerrero New Member

    Hi,

    This is my first post to this forum

    I'd like to know if there is a way to check why in my 2 node clustered sql server are missing the SQL Server performance counters

    I'm using the Performance Monitor console but I can't locate the SQL Server:* objects

    Do I have to enable them first or this is a problem ????

    SQL Server 2000+SP3 on Windows 2000 Advanced Servers+SP3

    Thank you very much and TIA


  2. satya Moderator

  3. gaurav_bindlish New Member

    This may sound harsh. Sorry about that.... Are you sure the SQL Server service is running on that box? I am asking this because the counters are not shown in the performance monitor if the service is not running. Also check if your service is running with some special flags enabled.

    Gaurav
  4. edgar_guerrero New Member

    Thanks for your reply...

    I've found this file:

    C:program FilesMicrosoft SQL ServerMSSQLBinnsqlctr.ini

    I've run this:

    lodctr "C:program FilesMicrosoft SQL ServerMSSQLBinnsqlctr.ini"

    But the counters are still missing...

    This is a SQL Server clustered in 2 nodes.

    The counters are missing in both.



  5. satya Moderator

    Unloaded and reloaded the counters by running the following commands on the active node:unlodctr mssqlserver$virtualservername
    lodctr <\virtualservername> g:mssql7innsqlctr.ini

    Also check values for the following registry keys :
    [hklmsoftwaremicrosoftwindows ntcurrent versionperflib09]
    [hklmsystemcurrentcontrolsetservicesmssqlserverperformance]


    _________
    Satya SKJ
  6. edgar_guerrero New Member


    Ok,

    After running both commands (unlodctr & lodctr)

    Looking in the registry the following key is empty:
    [hklmsoftwaremicrosoftwindows ntcurrent versionperflib09]
    the only value is:
    (Default)=(value not set)

    And the other one has this entries:
    [HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesMSSQLSERVERPerformance]
    "Library"="C:\PROGRA~1\MICROS~3\MSSQL\BINN\SQLCTR80.DLL"
    "Collect"="CollectSQLPerformanceData"
    "Open"="OpenSQLPerformanceData"
    "Close"="CloseSQLPerformanceData"
    "Last Counter"=dword:000013e4
    "Last Help"=dword:000013e5
    "First Counter"=dword:000012d0
    "First Help"=dword:000012d1
    "WbemAdapFileTime"=hex:00,2e,75,2c,1b,a6,c2,01
    "WbemAdapFileSize"=dword:00008238
    "WbemAdapStatus"=dword:00000000


  7. edgar_guerrero New Member



    After running the command:

    C:WINNTsystem32>lodctr \myvirtualsqlserver "c:program FilesMicrosoft SQL ServerMSSQLBinnsqlctr.ini"
    (line may wrap)


    The following error has appeared on EventLog->Application:

    Event Type:Error
    Event Source:LoadPerf
    Event Category:None
    Event ID:3009
    Date:4/29/2003
    Time:8:51:11 AM
    User:N/A
    Computer:SIDNEY
    Description:
    Installing the performance counter strings for MSSQLServer failed. The Error code is DWORD 0 of the Record Data.
    Data:
    0000: e5 03 00 00 å...
  8. chadiswar New Member

    I have seen this same behavior with the two clusters that I manage. Both systems are in an active/passive configuration. If you reboot the primary node and let it start the cluster resource, all counters are visiable. If you fail over to the second node after it has been rebooted, all the counters are visable. If for some reason, you have to "restart" the SQL service on a node that has been running cluster group, the performance counters will be gone. For example, node1 is running the cluster group, you then need to take it offline to do some work, if you bring it back online on node1 without restarting the system, the performance counters will be missing. If you are running on node1 and failover to node2, the performance counters will be available on node2 but if you fail back to node1 without restarting it first, the performance counters will be gone. This behavior began when I installed Windows 2000 SP3 and it does it on both clusters - one is IBM hardware and one is Dell hardware.

    Any information regarding this would be great.

    Chad
  9. chadiswar New Member

    I have seen this same behavior with the two clusters that I manage. Both systems are in an active/passive configuration. If you reboot the primary node and let it start the cluster resource, all counters are visiable. If you fail over to the second node after it has been rebooted, all the counters are visable. If for some reason, you have to "restart" the SQL service on a node that has been running cluster group, the performance counters will be gone. For example, node1 is running the cluster group, you then need to take it offline to do some work, if you bring it back online on node1 without restarting the system, the performance counters will be missing. If you are running on node1 and failover to node2, the performance counters will be available on node2 but if you fail back to node1 without restarting it first, the performance counters will be gone. This behavior began when I installed Windows 2000 SP3 and it does it on both clusters - one is IBM hardware and one is Dell hardware.

    Any information regarding this would be great.

    Chad
  10. satya Moderator

  11. JeannieT New Member

    Hi edgar_querrero,
    I have the exact same problem including the same error in event viewer running lodctr.

    I started having this problem with SP3.

    Did you find a resolution?

    Thanks

  12. Argyle New Member

    Same here. Get the exact same problem on a newly installed SQL 2000 cluster with SP3. No perfcounters on any node. Seems to be related to the MDAC upgrade that is made in SP3. I haven't been able to find any fix though. I've tried the above fixes without success.

    /Argyle
  13. biged123456 New Member

  14. alister New Member

    mi case is similar but not equal to yours:

    I get the same msg on event viewer when I try to install the microsft server desktop engine on a windows 2000 SP4 with windows update up to date. The installation progress bar goes backwards in the last moment with no error messages.

    I'm a bit lost, what can be the cause? This is not a clustered sql server and I don't know if my problem is related to yours.

    Some clue about this issue will be great.
    Thanks.
  15. satya Moderator

    Have you checked the referred KBA above and try to test & deploy the hotfix.

    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.
  16. alister New Member

    Sorry satya , buy I cant apply the patch exposed here; I think it may be cause my problem is DURING installation and not in a clustered server.

    As I have no MSDE installed yet, I have no Sqlctr60.dll nor sqlctr.ini.

    I continue with the message in eventviewer:
    Installing the performance counter strings for MSSQLServer failed. The Error code is DWORD 0 of the Record Data.

    When I try to install.


  17. satya Moderator

    THis is the reason there is a mismatch when SYSMON is invoked and trying to capture the SQL counters too. This generic KBAhttp://support.microsoft.com/kb/227662/EN-US/ deals with the SQL performance counters missing issue.

    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.
  18. alister New Member

    Before testing all the things that satya has adviced to me, I have upgraded to win XP for betatesting purposes. Unfortunately my problem persists, but winxp offers more info about the problem:


    Tipo de suceso:Advertencia
    Origen del suceso:WinMgmt
    Categoría del suceso:Ninguno
    Id. suceso:60
    Fecha:19/10/2005
    Hora:23:23:42
    Usuario:No disponible
    Equipo:ALISTER
    Descripción:
    WMI ADAP no puede procesar las bibliotecas de rendimiento: 0x80041001

    for those who dont understand spanish language: performance libs can't be processed (HUH)

    some events later...

    Tipo de suceso:Error
    Origen del suceso:LoadPerf
    Categoría del suceso:Ninguno
    Id. suceso:3002
    Fecha:20/10/2005
    Hora:0:06:07
    Usuario:No disponible
    Equipo:ALISTER
    Descripción:
    El valor de la cadena de explicación del contador de rendimiento en el registro tiene un formato incorrecto. La cadena incorrecta es Ä3, el valor de índice incorrecto es el primer valor DWORD en la sección de datos mientras que los últimos valores de índice correctos son el segundo y el tercer valor DWORD en la sección de datos.

    Para obtener más información, vea el Centro de ayuda y soporte técnico enhttp://go.microsoft.com/fwlink/events.asp.
    Datos:
    0000: 00 00 00 00 37 07 00 00 ....7...
    0008: 56 08 00 00 00 0b 00 00 V.......

    for those who dont understand spanish language: it seems I have broken some string value of the a performance counter, and this string has the value "Ä3" (so curious hehe)

    I think this happens because of registry problems, from all options proposed by satya.

    I'm tring to find out thes values in registry and, in worst case, delete them.

  19. alister New Member

    Resolved.<br /><br />I finally reconstructed the performance registry using a guide from windows help:<br /><br />Cómo reconstruir manualmente los valores de la biblioteca del Contador de rendimiento<br />(How to rebuild manually performance counters library values)<br /><br />Article ID.: 300956<br /><br />Overwriting the files perfc00X.dat and perfh00X.dat, and removing some registry values, MSSQL server installed successfully.<br /><br />Thanks a lot, mates. Now I can perform the f**ing betatesting of my company's software <img src='/community/emoticons/emotion-5.gif' alt=';)' /><br /><br /><br />

Share This Page