Skip to Content
avatar image
Former Member

DART 2.5 huge performance issue

Friends,

We are working on DART 2.5 version of the retention tool. We have been running the jobs in back ground. However the jobs are running for days just for one fiscal period selected, where the number of entries in BKPF table shows 30,000+. The job log shows the index table records inserted to TXW_INDEX and it hangs up there.

Any advice, how we can improve? We implemented all OSS notes relavant to perforamance still the same issue? Do we need to do any server level settings, we could have missed something?

regards

Nalin.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 23, 2009 at 03:18 PM

    Hi,

    To avoid the use of the temporary index table TXW_INDEX, set the maximum index memory allocation (extract configuration) to a value larger than the required temporary index memory. The temporary sort space is only used if the temporary index memory is below the limit set in the extract configuration

    Please refer to following links.

    Full detail in the following link.

    [http://help.sap.com/SAPHELP_ERP2005/helpdata/EN/b1/c9eba4864811d3817500c04fadb9d6/content.htm]

    [https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=142644]

    Make sure database statistics is updated regularly.

    Hope this helps.

    Manoj Chintawar

    Add comment
    10|10000 characters needed characters exceeded