I’m new with influx and I want to ask you for help. I think that i have some problems with configurtion or sql server plugin for telegraf have bug.
Few days ago i saw a lot of errors in telegraf log:
2019-11-08T13:36:50Z E! [outputs.influxdb] when writing to xxx: received error partial write: max-values-per-tag limit exceeded (100000/100000): measurement="sqlserver_requests"
I’m started to dig deeper and i found that sqlserver_request measurement have very high cardinality:
name: sqlserver_requests count ----- 194552
from 204K of Total! And the most of it is command tag(or column, tag key - i don’t know yet how to name it)
I’m use influx only to monitor VM’s with MS SQL server.
20 mayby 30 DB’s
I’m know that i can change limit for max-values-per-tag but it’s not a solution for me.
Can I do something to reduce series cardinality for sqlserver_requests??