i have a table that have 1 line, this top1 line will refresh every second by another software
in SQL server side, if i execute select the update query it will response very quickly
But in the ignition side , i found the update is very slow, sometimes 1 minutes, sometimes 3 minutes.
my setting update rate is 1s
i found not only this tag, but also other SQL tag have the same issue
i check the scada server task manager, seems the sql server memory and Cpu is very high.
i don’t know what block the query update,here is the ignition server status