SQL Server Performance Counters Missing | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server Performance Counters Missing

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

Usr LODCTR function to get them and refer thru this link http://www.sql-server-performance.com/performance_monitor_tips.asp] in this website. _________
Satya SKJ

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
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.
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 versionperflib 09]
[hklmsystemcurrentcontrolsetservicesmssqlserverperformance]
_________
Satya SKJ


Ok, After running both commands (unlodctr & lodctr) Looking in the registry the following key is empty:
[hklmsoftwaremicrosoftwindows ntcurrent versionperflib 09]
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

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 Ã¥…

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
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
Refer to this KBA http://support.microsoft.com/defaul…ort/kb/articles/Q246/3/28.asp&NoWebContent=1] though it refers for 6.5 & 7. _________
Satya SKJ

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
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
Hotfix available for the problem I believe. It was introduced with SQL2000 Sp3. Check your SQL error logs for the error. Performance monitor shared memory setup failed: -1 http://support.microsoft.com/default.aspx?scid=kb;en-us;812915
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.

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

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.
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.
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 />
]]>