Has anyone had a problem where reports work well for several day, but then the queries take too long, effectively becoming unusable?
Ignition Server CPU 8-20% Memory 4gb/10gb usage.
Database server 2% CPU , 2gb/32gb usage.
The reports are fine immediately after restarting the ignition server, I'm not sure what to look for as I'm sure this will happen again every few days but there is no memory leak (that I know of) and the CPU usage is not high.
Didn't restart the data server, just ignition server.
Any hints or tips would be useful !