I have a database connection which seems to be overworking the CPU with way too much activity. When I disable this connection the CPU usage goes right back down to normal. I can see that the query throughput is abnormally high. When I create the same database connection with an identical copy of the database on another machine, there is no unusual activity, so the problem seems local to the database in question. Is there a way to find out which projects/processes are causing the database connection to continually flood the database with queries and why it would not happen on another machine with an identical backup of that database?
I can see which queries are active but can I see where in ignition they’re being called from?