My store and forward is unavailable due to Memory sink is full Data cache is full what is the reason and how can i solve it ? i have total dropped data over 119,555,663 records and i been doing it manually to clear some space the memory buffer is 100% 2500/2500 and local cache is 100% 25000 /25000 please any answer
It means your database is broken or simply not fast enough.
Share more details about your setup.
Share the details about your database, because that is what is broken.
-
What DB brand and version?
-
Where is the DB located? (Same machine? Same LAN? Nearby data center? Far away data center?)
-
What query rate is the DB connection status page showing? (Screenshot that.)
MicrosoftSQLserver its on same Lan and here is a screenshot of the queryrate
Show the status details page for that S&F engine. That will show the corresponding data delivery rate. (I suspect your DB is simply not powerful enough for the number of tags you are trying to historize.)
Your connections are almost completely saturated. Pretty much aligns with what @pturmel is saying about the database not being powerful enough.
Is the server that the database is on showing any issues?
3 Likes
Is this server a VM or a Physical Server?
How much RAM is available on the server?
Are there any other applications running on the same server as the SQL server, or is it a standalone server?