# Memory sink is full Data cache is full

**URL:** <https://forum.inductiveautomation.com/t/memory-sink-is-full-data-cache-is-full/103713>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [March 14, 2025, 4:50pm UTC](https://forum.inductiveautomation.com/t/memory-sink-is-full-data-cache-is-full/103713 "2025-03-14T16:50:23Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![abdulwahhab](https://avatars.discourse-cdn.com/v4/letter/a/87869e/32.png) [@abdulwahhab](https://forum.inductiveautomation.com/u/abdulwahhab)\
**Post date:** [March 14, 2025, 4:50pm UTC](https://forum.inductiveautomation.com/t/memory-sink-is-full-data-cache-is-full/103713/1 "2025-03-14T16:50:23Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [March 14, 2025, 4:52pm UTC](https://forum.inductiveautomation.com/t/memory-sink-is-full-data-cache-is-full/103713/2 "2025-03-14T16:52:29Z")

</div>

It means your database is broken or simply not fast enough.

Share more details about your setup.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [March 14, 2025, 5:07pm UTC](https://forum.inductiveautomation.com/t/memory-sink-is-full-data-cache-is-full/103713/5 "2025-03-14T17:07:30Z")

</div>

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.)

---

<div class="post-metadata">

**Author:** ![abdulwahhab](https://avatars.discourse-cdn.com/v4/letter/a/87869e/32.png) [@abdulwahhab](https://forum.inductiveautomation.com/u/abdulwahhab)\
**Post date:** [March 14, 2025, 5:16pm UTC](https://forum.inductiveautomation.com/t/memory-sink-is-full-data-cache-is-full/103713/6 "2025-03-14T17:16:38Z")

</div>

MicrosoftSQLserver its on same Lan and here is a screenshot of the queryrate  
 ![Capture](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/2/c2d7782344e694ac5999734115e2a658b5653358.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [March 14, 2025, 5:19pm UTC](https://forum.inductiveautomation.com/t/memory-sink-is-full-data-cache-is-full/103713/7 "2025-03-14T17:19:51Z")

</div>

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.)

---

<div class="post-metadata">

**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\
**Post date:** [March 14, 2025, 5:21pm UTC](https://forum.inductiveautomation.com/t/memory-sink-is-full-data-cache-is-full/103713/8 "2025-03-14T17:21:29Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [March 14, 2025, 5:44pm UTC](https://forum.inductiveautomation.com/t/memory-sink-is-full-data-cache-is-full/103713/9 "2025-03-14T17:44:57Z")

</div>

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?
