Rebuild SQL performance counters
Hi there, I'm running SQL 2014 Express on Windows 2016 (coming with Skype server). The issue is, I have no other performance counters for SQL than agents: Get-Counter -ListSet sql* | Sort-Object -Property CounterSetName | ft CounterSetName CounterSetName -------------- SQLAgent$LYNCLOCAL:Alerts SQLAgent$LYNCLOCAL:Jobs SQLAgent$LYNCLOCAL:JobSteps SQLAgent$LYNCLOCAL:Statistics SQLAgent$LYNCLOCAL:SystemJobs SQLAgent$RTCLOCAL:Alerts SQLAgent$RTCLOCAL:Jobs SQLAgent$RTCLOCAL:JobSteps SQLAgent$RTCLOCAL:Statistics SQLAgent$RTCLOCAL:SystemJobs The first advice I have found for this is to use command: lodctr perf-MSSQLSERVERsqlctr.ini But my issue is, that I do not have that file on my server. Neither if I'm looking for the registry under SQL services, I'm missing "performance" hive: PS C:\> Get-ChildItem -Path 'HKLM:\System\CurrentControlSet\Services\MSSQL$LYNCLOCAL\' Hive: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MSSQL$LYNCLOCAL Name Property ---- -------- Linkage Export : {LYNCLOCAL} Does anybody knows if I'm able to get SQL's performance counters visible? Or is this W2016 and SQL 2014 express issue?
