Possible [perfmon://sqlserver:memory_manager] stanza typos

[jwiedow]

It appears there is a typo in inputs.conf for the [perfmon://sqlserver:memory_manager] stanza in the counters line.

We are not receiving any data in Splunk for the Total Server Memory(KB) counter.

The following search will return zero results:

index=main collection="sqlserver:memory_manager" counter="Total Server Memory(KB)"

The following search will also return zero results:

index=main collection="sqlserver:memory_manager" counter="Target Server Memory(KB)"

where this will return results

index=main collection="sqlserver:memory_manager" counter="Target Server Memory (KB)"

[jwiedow · Accepted solution]

The issue is in the inputs.conf of the Splunk Add-on for Microsoft SQL Server.

The following stanza is missing a space between Memory and (KB) and has a duplicate counter value for Target Server Memory(KB).

Bad Stanza

[perfmon://sqlserver:memory_manager]

object = (SQLServer|MSSQL[^:]*):Memory Manager

counters = Total Server Memory(KB);Target Server Memory(KB);Granted Workspace Memory (KB);Maximum Workspace Memory (KB);Memory Grants Outstanding;Memory Grants Pending;Target Server Memory (KB)

interval = 60

showZeroValue = 1

disabled = 1

Corrected Stanza

[perfmon://sqlserver:memory_manager]

object = (SQLServer|MSSQL[^:]*):Memory Manager

counters = Total Server Memory (KB);Granted Workspace Memory (KB);Maximum Workspace Memory (KB);Memory Grants Outstanding;Memory Grants Pending;Target Server Memory (KB)

interval = 60

showZeroValue = 1

disabled = 1