How i can maintain cache DB

Question

Question

Ayman Yousef · Aug 2, 2017

Hello,

I need support for my case!!
I have 18 GB health care cache Database i face delay with filter and transmit data around 20 - 45 Minutes, I need solution to fixed my issue.

I did Rebuild indexes & Tune Table .

Thanks,

Discussion (5)2

Log in or sign up to continue

Robert Cemper · Aug 2, 2017

The first thing to check in Mgmt Portal is size of Global Buffers - Rule of thumb: 50% of available RAM
http://<yourhost>:<yourport>/csp/sys/mgr/%25CSP.UI.Portal.MemoryStartup.zen

Check Cache Efficiency in System Dashboard before and after restart
http://<yourhost>:<yourport>/csp/sys/op/UtilDashboard.csp?$NAMESPACE=

2 0

score 0 · Answer 1 · 2017-08-02T06:30:38-04:00

There is by no means enough information here to help you. If this is an urgent problem, you should contact InterSystems Support. Otherwise, we need a lot more information regarding what your problem is.

score 0 · Answer 2 · 2017-08-02T06:54:23-04:00

Thank you for you replay.

The memory 25% of the RAM and I checked cache efficiency before restart 77,644.17 after restart 69.25.

score 0 · Answer 3 · 2020-11-15T15:22:00-05:00

‎It really lacks a lot of information, but to be quick and straightforward, you could locate the bottleneck point and one of the ways to achieve this is by identifying the process that is slow.‎

‎In the administration portal, go through processes, find the process that is slow and keep updating it, see if it is running or if there is any routine that becomes more evident, so you can understand exactly what is happening.‎

‎If there are no crashes at specific points, it may be some repeating structure or something in the programming logic, so I recommend using the tool in this article:‎

http://localhost:57772/csp/docbook/DocBook.UI.Page.cls?KEY=GCM_monlbl

score 1 · Answer 4 · 2022-03-29T07:41:44-04:00

@Ayman Yousef - here is the public documentation for the tool that @Arian Botine mentioned (which is a very useful tool):

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...