Skip to Content
avatar image
Former Member

Self Tuning in Data Services 4.2

Dear experts,

Regarding self tuning feature of Data Services which can be enable by turning on Collect Statistics for Optimization and Use Collected Statistics, I want to ask the procedure to clear all the statistics collected. Could you kindly help me?

Thank you very much.

Best regards,
Theo Tando

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 31, 2014 at 09:15 AM

    Disclaimer: officially unsupported!

    Statistics are kept in the AL_CACHE and AL_CACHE_STATS repository tables. You can get rid of them by deleting all records from those tables.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Dirk Venken

      Dear Venken,

      The dataflows are set to In-Memory Cache.

      So, if the statistics is only used when the dataflows are pageable, meaning that the different performance are not caused by self tuning, since it is overridden by in-memory setting applied.

      Let me check the trace log first then tell you the result.

      Thanks Venken.

      Best regards,

      Theo Tando

  • avatar image
    Former Member
    Dec 31, 2014 at 04:00 AM

    Dear experts,

    I also want to ask about Data Services performance.

    I have a job which has statistics like this:

    1st run: 16 minutes 19 seconds

    2nd run: 16 minutes 53 seconds

    3rd run: 16 minutes 23 seconds

    4th to x-th runs: approx 12 minutes

    I want to ask why this can happen. I run the job in a server which has no other process running, and there is no performance tuning conducted.

    I suspect that the self tuning feature is the reason behind this. But why did the improvement only occur at the 4-th run? Is there any other factor that can cause this performance improvement?

    Thank you very much.

    Best regards,

    Theo Tando

    Add comment
    10|10000 characters needed characters exceeded

    • What about your source and target datastores? Your network load?

      I mean, there are external factors that may influence performance, too. Don't always blame it on DS .

      Compare the monitor log output of 3rd and 4th run and try to narrow down, find out where the difference womes from.