NVPS query

[VectorAudioUK]

Does anyone have an SQL query or any other way, to get which hosts are posting the most new values. We're currently running at 1194 NVPS with 1274 hosts and everything is running ok-ish but occasionally seeing high disk activity alarms. I'd like to check to see if anything is particularly posting a large amount of values.

Thanks

[Hamardaban]

zabbix[requiredperformance]

Required performance of Zabbix server or Zabbix proxy, in new values per second expected.			Float.	Approximately correlates with "Required server performance, new values per second" i

You will not get it from the database because the value is calculated on the fly in the server's (proxy) memory .