I have a business reason, the data server, decorate the kettle to extract data; Orcale database, PLSQL developer tools, orcale developer tools, etc.; Every time use, than low CPU and memory, calculation is slow; Clearly there are a lot of resources but unable to use, improve efficiency of upset, have bosses to give directions, thank you


12 r * Windows server 64
2 * 10 c10t CPU
128 g

CodePudding user response:

High efficiency too empty, to specific analysis why efficiency is low, most of the time is caused by the poor quality of SQL,

If just want to improve the CPU/memory utilization, and can be used in parallel mode, need to be careful, take resources so as to avoid each other,

CodePudding user response:

Is not the same as the low CPU memory system can withstand greater pressure, the bottleneck of data blocks a lot of time on the IO, prop your storage devices also have to live? If it is, then refer to the upstairs, increase your concurrent, and control your concurrent,

CodePudding user response:

Feel the kettle this tool itself efficiency is lower