Rebuild SQL performance counters

Super Contributor

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?

0 Replies