How to find out which source writes the most to the historian database

Ignition
1

hi All
How would you check which source of historic data writes the most of data volume to the historian database? Gateway status provides info about the traffic which is mostly Select queries not inserts.
This finding would be later used to decrease the volume by optimising the frequency etc.

Regards

2

Do a select against a partition table grouping by tag id and delivering the row count. Join that against the meta-data to get the tag path.

2 Likes