I am unable to see MSSQL KPIs in ITSI. Below is what I have done so far -
- Installed SQL TA, DBX2 & Windows TA
- configured lookup in SQL TA for host & port
- I am able to see data into Splunk
But I don't following fields that populates DB KPIs -deadlock_rate, server, read_iops, server_write_iops, response_time, connections, connection_pool_used_percent, transaction_rate.
Search for datamodel has produced following results -
I am suspecting problem with tag=server field which does not produce any results.
index=* tag=database tag=performance tag=server
Could someone please advise me how to fix this problem.
Thanks in advance.
... View more