Add a sql server performance counter

Telegraf
2

You are missing a part (or maybe you forgot it) and there might be a TOML escaping-related issue

when using double quotes / must be escaped in strings, meaning it has to be written as //. to avoid it you can use single quotes

[[inputs.win_perf_counters]] <-- this was missing
  [[inputs.win_perf_counters.object]]
  ObjectName = “MSSQL$xxxxx:Locks”
  Instances = [“_Total”]
  Counters = ['Lock Requests/s'] <-- single quotes here
  Measurement = “sql_locks”

Since you are getting it from perfmon it should work.

1 Like