August 11, 2005 at 6:26 am
Hi All,
I have a SQL Server 2000 on WIndows 2000 machine. When I go in Perfromance Monitor, I do not see the SQL Server counters existing on my machine.
How can I get my SQL Counters in Performance Monitor. ?
Thanks,
Kishore
August 11, 2005 at 6:33 am
There is a known bug where the SQL Server perf counters are missing if Perfmon is running while SQL Server is restarted. Stop Perfmon and restart SQL Server, then start Perfmon again and the counters will be there.
August 11, 2005 at 7:33 am
The Bug Mentioned by Chris is fixed in Hotfix of SQL Build 780 and is documented in KB artile http://support.microsoft.com/default.aspx?scid=kb;en-us;812915 . If your SQL Server build is above 780, the issue is probably something different other wise consider applying SQL Server Security Patch MS03-031 or SP4 (Both these upgrades include this hot fix).
You may also try running the following commands from command prompt to reload the Perf counters.
unlodctr.exe MSSQLServer
lodctr.exe SQLCTR.INI (give full path of these files on your machine)
Restart the machine
Hope this helps
M.S. Reddy
August 12, 2005 at 3:20 am
There is another potential cause, and it is the one that I suffered from last year. Basically its a permissions issue. Can't remember the exact details, but it was my problem. Basically I was running sql server under a user account, and the counters did not have permissions on it. I seem to recall the Performance Logs and Alerts service defaults to Network Service logon.
By switching it to the local system logon this seemed to fix the lack of counters.
Anyone got input to the security ramifications of that choice?
August 12, 2005 at 5:34 am
Solution mentioned by Chris did not work for me. Is shall try out the other solutions and let you know. Thanks for the replies.
--Kishore
August 15, 2005 at 3:42 am
Wondering if you managed to resolve your issue?
August 15, 2005 at 2:38 pm
I have this same issue and have not found any way to fix it so far. My counters come back after reboot and then disappear after 12 hours. I believe it is some kind of interaction between the medical software application that uses SQL on that machine.
August 16, 2005 at 3:36 am
Check the logon for the performance counter service.
September 6, 2005 at 12:39 pm
In a response to this problem a hotfix build 780 is mentioned as a workaround to address the missing performance monitor stats. I have look on microsoft for the build 780 and even the kb artible but am unable to locate the hotfix. does anyone have any ideas of exactly where to go to get the hotfix 780
October 7, 2005 at 9:29 am
Hi. I encountered the issue a couple of times doing performance testing against SQL Server. Microsoft's explanation is that one or more of the related 'performance extension DLLs is disabled'. To enable the related 'performance extension DLL' one can use the Microsoft W200x Resource Kit or modify the registry.
Within the Microsoft W200x Resource Kit, one needs to use the 'ExCtrlList utility', which is quite easy. However obtaining the Resource Kit is initially required (downloading &/or purchasing - ?).
In any case, a full explanation of missing Performance Counters is documented in Microsoft's support knowledge base article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;248993
Regards,
Roy Sternweiler
October 18, 2008 at 12:57 am
hi kishore
1st check in ur application log is there any error
there will be a column source in that u will get perflib with error
2nd
go the C:\WINDOWS\SysWOW64 and double click on Perfmon.exe
then check it out u will get the counters.....
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply