February 10, 2010 at 11:35 am
Hi..
i am seeing this error message in the sql server errorlog file.
Cannot query value 'First Counter' associated with registry key 'HKLM\SYSTEM\CurrentControlSet\Services\MSSQL$NEW\Performance'. SQL Server performance counters are disabled.
can you tell me how to resolve this issue ?
Thanks in advance.
July 18, 2010 at 7:54 am
I think it is related to permissions
try changing MSSQLSERVER service login to "Local System"
on my box the problem went at that point
I still haven't located the exact problem yet - Audit on Registry hasn't shown anything yet
I have audited these keys so far:
hklm\software\microsoft\windows nt\currentversion\perflib
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\Performance]
[edit] oh yes forgot to mention also that registry keys were missing, this is export from working server:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\Performance]
"Library"="sqlctr90.dll"
"Open"="OpenSQLPerformanceData1"
"Collect"="CollectSQLPerformanceData1"
"Close"="CloseSQLPerformanceData1"
"PerfIniFile"="perf-MSSQLSERVERsqlctr.ini"
"WbemAdapFileSignature"=hex:ea,d9,2a,ed,c0,14,64,62,74,5c,95,23,84,cb,ba,9d
"WbemAdapFileTime"=hex:00,ae,70,f0,ea,4e,c9,01
"WbemAdapFileSize"=dword:00015b60
"WbemAdapStatus"=dword:00000000
"Last Counter"=dword:00003fd8
"Last Help"=dword:00003fd9
"First Counter"=dword:00003d64
"First Help"=dword:00003d65
"Library Validation Code"=hex:00,ae,70,f0,ea,4e,c9,01,60,5b,01,00,00,00,00,00
July 18, 2010 at 11:22 am
doobya (7/18/2010)
I think it is related to permissionstry changing MSSQLSERVER service login to "Local System"
on my box the problem went at that point
I still haven't located the exact problem yet - Audit on Registry hasn't shown anything yet
I have audited these keys so far:
hklm\software\microsoft\windows nt\currentversion\perflib[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\Performance]
[edit] oh yes forgot to mention also that registry keys were missing, this is export from working server:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\Performance]"Library"="sqlctr90.dll"
"Open"="OpenSQLPerformanceData1"
"Collect"="CollectSQLPerformanceData1"
"Close"="CloseSQLPerformanceData1"
"PerfIniFile"="perf-MSSQLSERVERsqlctr.ini"
"WbemAdapFileSignature"=hex:ea,d9,2a,ed,c0,14,64,62,74,5c,95,23,84,cb,ba,9d
"WbemAdapFileTime"=hex:00,ae,70,f0,ea,4e,c9,01
"WbemAdapFileSize"=dword:00015b60
"WbemAdapStatus"=dword:00000000
"Last Counter"=dword:00003fd8
"Last Help"=dword:00003fd9
"First Counter"=dword:00003d64
"First Help"=dword:00003d65
"Library Validation Code"=hex:00,ae,70,f0,ea,4e,c9,01,60,5b,01,00,00,00,00,00
Thank you .
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply