sql server 2014 Visu+ SCADA Query timeout exceeded on SQL Server 2014

[Bruna Pozzato Tavares 0]

I have an application in the Visu+ Scada System, from Phoenix Contact, which makes a query in the SQL Server 2014 database.
While the database was empty, queries were made perfectly, after 4 months the database grew up absurdly and then stopped running the query, returning the following error: Query timeout exceeded.

I have a general table with 210 variables being written every 20 seconds. The query is made by updating the parameters in another single row table, it generates a trigger that copies the requested query to a third table and it is plotted on a chart in the supervisory system.

The error occurs when Visu+ sends the parameters to be updated in the second table, returning "Query timeout exceeded.". However, when I update directly through SQL Server, it updates, generates the trigger and performs the requested query.

Could someone help me solve this timeout problem, please?
Thank you very much in advance!!