May 14 2021 06:25 AM
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?