# Vision Alarm journal ressources **URL:** \ **Category:** Ignition\ **Tags:** database, ignition81, vision\ **Created:** [March 28, 2024, 2:38pm UTC](https://forum.inductiveautomation.com/t/vision-alarm-journal-ressources/88034 "2024-03-28T14:38:43Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Michael\_Gagne](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@Michael\_Gagne](https://forum.inductiveautomation.com/u/Michael_Gagne)\ **Post date:** [March 28, 2024, 2:38pm UTC](https://forum.inductiveautomation.com/t/vision-alarm-journal-ressources/88034/1 "2024-03-28T14:38:43Z")
Hi All, Over the past year an a half a client mentionned that sometimes the Server PC would freeze, they had to restart it (windows was not froze). I was able to see from my own eyes one time and looks like it was when the Alarm History (Alarm Journal) page was open. I did check PC ressources and the CPU was struggnling pretty bad. CPU load was \> 90% just for the Zulu platform process. Restarting the view client does fix it (no need to reboot PC). After that, I manually tried to redo the bug but it didn't happen again. When I tried to manually do it, I tried displaying alarms from the last 24h, last week and even from all last months but it did not torch the CPU, was normal load on CPU. Totally forgot to write here but the problem is clearly not fix, just happend while I was remote connected to the system (the client had the Journal open). System was originally on 8.1.22 and we updated last December to 8.1.33, no change to the effect, it crashed before the update and also after. Any ideas where to look at first? Thanks, First screenshot is when its' happening and second is after a restart, showing alarms from last month ~19K alarms. ![2024-02-02 17_52_38-](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/3/037c036df65768db352465bc1448990f913c57a0.jpeg) ![2024-02-02 19_16_19-pcs1 - TightVNC Viewer](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/d/1d5787ec112e3009c879a2fcd361161d606df066.jpeg) ---
**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 28, 2024, 3:37pm UTC](https://forum.inductiveautomation.com/t/vision-alarm-journal-ressources/88034/2 "2024-03-28T15:37:23Z")
If the database is on the same machine as the gateway, there can be pathological contention between the two. Is the machine hosting both gateway and database? ---
**Author:** ![Michael\_Gagne](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@Michael\_Gagne](https://forum.inductiveautomation.com/u/Michael_Gagne)\ **Post date:** [March 28, 2024, 3:50pm UTC](https://forum.inductiveautomation.com/t/vision-alarm-journal-ressources/88034/3 "2024-03-28T15:50:16Z")
It does ---
**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 28, 2024, 4:26pm UTC](https://forum.inductiveautomation.com/t/vision-alarm-journal-ressources/88034/4 "2024-03-28T16:26:57Z")
I will be difficult to untangle the database impact while querying the journal from the handling of that data in the gateway as long as they are in the same machine. Plan on fixing that, as you may not be able to solve this otherwise. (Putting a database on the same machine as a gateway is only suitable for development or trivial testing.) ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [March 28, 2024, 6:58pm UTC](https://forum.inductiveautomation.com/t/vision-alarm-journal-ressources/88034/5 "2024-03-28T18:58:10Z")
Curious as to what all is running on this IPC. The alarm manager stuff, I would say, is not Ignition, DB, or Windows related. ---
**Author:** ![Michael\_Gagne](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@Michael\_Gagne](https://forum.inductiveautomation.com/u/Michael_Gagne)\ **Post date:** [April 3, 2024, 12:36pm UTC](https://forum.inductiveautomation.com/t/vision-alarm-journal-ressources/88034/6 "2024-04-03T12:36:47Z")
Seems that writing to DB and running the Gateway is perfectly fine, the system is operational since Dec 2022. I do get your point but adding another computer just for the DB is going cost alote more and space is also very limited. One thing I could do is at least test the theory using another PC while the vessel is doecked in the next weeks. ---
**Author:** ![Michael\_Gagne](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@Michael\_Gagne](https://forum.inductiveautomation.com/u/Michael_Gagne)\ **Post date:** [April 3, 2024, 12:40pm UTC](https://forum.inductiveautomation.com/t/vision-alarm-journal-ressources/88034/7 "2024-04-03T12:40:25Z")
Not much actually, the MySQL DB, the Gateway and a viewer, that's it. From the screen shot you can see that it is the Zulu Platform Process related to Ignition that is eating at the CPU, nothing else. The rest might be 5-10% CPU which is just normal. It is clearly related to opening the Alarm Journal mimic, perhaps it a configuration issue but i'm fraily certain it is not something else. ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [April 3, 2024, 5:33pm UTC](https://forum.inductiveautomation.com/t/vision-alarm-journal-ressources/88034/8 "2024-04-03T17:33:51Z")
If your total memory usage is that low, you could probably allocate more memory to the vision client in the project properties.