Missing metrics related to memory clerk (memory breakdown), database size, database stats, database io, OS volume, wait status

The below metrics are obtained in the output file of telegraf (query_version 1) but are missing in the version (query_version 2):
Database stats
Database io
Database size
Memory clerk
OS volume
Wait stats

System info:
telegraf version : 1.10.0
sqlserver : win 2012R2
prometheus database

Relevant telegraf.conf:
[[inputs.sqlserver]]
servers = [“Server=localhost;Port=1433;User Id=telegraf;Password=Mystrongpassword@01;app name=telegraf;log=1;”,]
query_version = 2

How to get these metrics using the latest version of telegraf (query_version 2)?