Hi,
I am using SCD stage to maintain Dimension tables. The volume of data is more than 20 Million records. What would be the process or steps to calcualte the memory usage of the job or scd stage. Some times the jobs uses maximum of RAM and other jobs does not have sufficient memory.
Should I use "nmon" in unix to monitor the memory? How to calculate the rows to memory approximately ?
Calculating memory usage for SCD
Moderators: chulett, rschirm, roy
Calculating memory usage for SCD
Thanks, BK
Re: Calculating memory usage for SCD
It could be for the whole job:
You can use ps -o | grep job name. Then you can calculate.
Right now i am not in front of system (now in windows) to check this! But it should work.
Or
You can try pmap kind of command.
You can use ps -o | grep job name. Then you can calculate.
Right now i am not in front of system (now in windows) to check this! But it should work.
Or
You can try pmap kind of command.
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.