Acceleration of Oracle remote checks through parallelism
Monitoring of many Oracle databases is a typical enterprise monitoring use case. Built-in Checkmk remote monitoring requires too much execution time when the number of monitored databases becomes too large.
I suggest to parallelize main parts of the mk_oracle plugin or the plugin itself to shorten its overall run-time.
In our custom variant of the Oracle remote monitoring plugin we already do that. Please check if such an optimization can be taken over into the built-in remote Oracle monitoring plugin.
Example execution times with 62 DBs
built-in mk_oracle: 3m 12s
custom, parallelized mk_oracle.sh: 9s
Comments: 2
-
08 Aug, '22
Lars SörensenWith the MAX_TASKS Option (introduced with CMK 2.1) you can define how many SID should be check in parallel.
https://checkmk.com/werk/11520
I believe this works only for local databases, not for remote queries. But it should be easy to implement the analog for remote instances. -
18 Oct, '23
Marcel Arentz AdminHello,
Thank you for your idea. On this portal, we carefully evaluate ideas to ensure that they will benefit a wide range of users. Thus, we close ideas not fulfilling certain criteria:
- Suggestions with low user interest: created more than 1 year ago with 5 votes or less
- Suggestions with no momentum: no votes in the last 6 months
Unfortunately, this suggestion doesn't meet these criteria, so we’re closing it (based on the data available until 2023-10-17). We appreciate your contribution and encourage you to continue to share your ideas. Your input plays a vital role in helping us improve our product for everyone.
Thank you for your understanding and continued support!
Warm regards,
Your Checkmk Team