My database Storage in the store and forward status page is showing as “Idle”. As a result the local cache is filling up. The SQL Database which is running in azure seems to be performing fine according to the azure portal metrics (CPU usage is very low, as is the I/O reading. Running queries on the management studio is working fine and showing no performance issues. The connection to the DB is valid and we have never had an issue with this database before. Partitioned weekly with roughly 5 million rows in each table. Disabling and re-enabling the connection has not worked. Restarted the gateway and tag historian multiple times. Log files do not indicate anything unusual
Any help would be much appreciated.