SQL Server Input Plugin - missing IO data

Hi

I am in the process of looking at mssql data using the latest telegraf plugin. From what I can gather I should be collecting the IO, Data read/write, log read/write along with the latencies.

Reviewing the influxdb data. This doesn’t appear to be the case. I see that there has been some changes throughout. Is there a potential that I missing from the plugin? Or need to enable it?

Thanks

can anyone assist, please?

Have you set the query version in the config?

## Optional parameter, setting this to 2 will use a new version
## of the collection queries that break compatibility with the original
## dashboards. All new functionality is under V2
query_version = 2

Hi Katy

Thank for the response. Yes this set on the configuration file. This is basically what the config looks like

  ## Optional parameter, setting this to 2 will use a new version
  ## of the collection queries that break compatibility with the original
  ## dashboards. All new functionality is under V2
  query_version = 2

  ## If you are using AzureDB, setting this to true will gather resource utilization metrics
  # azuredb = true

  ## If you would like to exclude some of the metrics queries, list them here
  ## Possible choices:
  ## - PerformanceCounters
  ## - WaitStatsCategorized
  ## - DatabaseIO
  ## - DatabaseProperties
  ## - CPUHistory
  ## - DatabaseSize
  ## - DatabaseStats
  ## - MemoryClerk
  ## - VolumeSpace
  ## - Schedulers
  ## - AzureDBResourceStats
  ## - AzureDBResourceGovernance
  ## - SqlRequests
  ## - ServerProperties
  exclude_query = [ 'Schedulers' , 'SqlRequests']

You should try to execute the query manually on your SQL Server instance and check its results. The tsql can be found in the Telegram GitHub repository

From the code you will also see the difference between version 1 and 2 of the queries.

In your case the values are completely missing or always 0?