There are many reasons why memory usage walk through investigation has to be done.
Memory can easily be occupied. Very high peak used memory is bad news in production.
In order to avoid that type of situation, it is crucial to test and validate new batch procedure before going to production.
Let's discover what to investigate during test and validation.
Here are the different points to look at:
1- Data size before starting.
2- Data size after it has been finished.
3- Data delta after it has been finished.
4- Used memory size history from the time data load started.
5- Check how fast used memory has been growing.
6- Check how fast used memory has been released.