Rebuild SQL performance counters

%3CLINGO-SUB%20id%3D%22lingo-sub-2354736%22%20slang%3D%22en-US%22%3ERebuild%20SQL%20performance%20counters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2354736%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3EI'm%20running%20SQL%202014%20Express%20on%20Windows%202016%20(coming%20with%20Skype%20server).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20issue%20is%2C%20I%20have%20no%20other%20performance%20counters%20for%20SQL%20than%20agents%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-powershell%22%3E%3CCODE%3EGet-Counter%20-ListSet%20sql*%20%7C%20Sort-Object%20-Property%20CounterSetName%20%7C%20ft%20CounterSetName%0A%0ACounterSetName%0A--------------%0ASQLAgent%24LYNCLOCAL%3AAlerts%0ASQLAgent%24LYNCLOCAL%3AJobs%0ASQLAgent%24LYNCLOCAL%3AJobSteps%0ASQLAgent%24LYNCLOCAL%3AStatistics%0ASQLAgent%24LYNCLOCAL%3ASystemJobs%0ASQLAgent%24RTCLOCAL%3AAlerts%0ASQLAgent%24RTCLOCAL%3AJobs%0ASQLAgent%24RTCLOCAL%3AJobSteps%0ASQLAgent%24RTCLOCAL%3AStatistics%0ASQLAgent%24RTCLOCAL%3ASystemJobs%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20first%20advice%20I%20have%20found%20for%20this%20is%20to%20use%20command%3A%3C%2FP%3E%3CP%3Elodctr%20%3CFONT%20color%3D%22%23FF0000%22%3Eperf-MSSQLSERVERsqlctr.ini%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20my%20issue%20is%2C%20that%20I%20do%20not%20have%20that%20file%20on%20my%20server.%20Neither%20if%20I'm%20looking%20for%20the%20registry%20under%20SQL%20services%2C%20I'm%20missing%20%22performance%22%20hive%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-powershell%22%3E%3CCODE%3EPS%20C%3A%5C%26gt%3B%20Get-ChildItem%20-Path%20'HKLM%3A%5CSystem%5CCurrentControlSet%5CServices%5CMSSQL%24LYNCLOCAL%5C'%0A%0A%20%20%20%20Hive%3A%20HKEY_LOCAL_MACHINE%5CSystem%5CCurrentControlSet%5CServices%5CMSSQL%24LYNCLOCAL%0A%0AName%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20Property%0A----%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20--------%0ALinkage%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20Export%20%3A%20%7BLYNCLOCAL%7D%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anybody%20knows%20if%20I'm%20able%20to%20get%20SQL's%20performance%20counters%20visible%3F%20Or%20is%20this%20W2016%20and%20SQL%202014%20express%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2354736%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQL%20Express%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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