sqlserver: Completing Query Store related Performance counters

[dba-leshop]

Feature Request

Opening a feature request kicks off a discussion.

Proposal:

Adding following performance counters:

• Query Store logical reads
• Query Store logical writes
• Query Store physical reads

Cf. Microsoft Docs

Current behavior:

Currently, only Query Store CPU usage is included to performance counter query.

Desired behavior:

Getting additional Query Store IO related performance counters

Use case:

To enhance Query Store usage monitoring

[sspaink]

This seems like it could be a good addition to the sqlserver, I assume it could be as easy as extending this select statement: https://github.com/influxdata/telegraf/blob/master/plugins/inputs/sqlserver/sqlserverqueries.go#L416 to get the additional counters?

@dba-leshop would you be interested in perhaps creating a pull request implementing this change?

[dba-leshop]

@sspaink Sure. I will do it