Skip to Content

Parts Tuning of data load on example of BW Statistics – Episode 1 – Analysis and Tuning of data load on example of BW Statistics – Episode 2 – Further Analysis. 

[2007-02-11] Loads took 7hours.

[2007-02-19] Well, I think I have my ideas now on how to improve loads.

1) I checked how many new SIDs are created during one load:

  • 286,683 in S-table of 0TCTSTAUID
  • 144,235 in S-table of 0TCTTIMSTMP

Ideal to use number range buffering (Note 130253) – just like John and Jay recommended.

2) Another promissing note is 152683 – Buffering master data tables, that recommend to change the buffer setting of lagre master data tables (as above) from ‘single record buffered’ to ‘not buffered’.

[2007-09-20] It is time to close this diary as it is. I am not at that project anymore.

I came with above proposals to guys responsible for performance in that system, and … got 2 page-length forms to populate and heard that I have to follow Change Management process. I.e. I need to do tests in Dev, then … user testing in QA, and then go thru … Go-Live checklist before moving this to production.

I am not good in processes, so I gave up. Until today loads take several hours, but at least procedure has not been broken. Sad, but true.

I know this weblog was supposed to be about technical solution. But the end is written by the Life.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply