TDMS: Data Selection and Data Transfer phase taking running longer time than expected

[Former Member]

Hi, I am running TDMS ECC package time slice reduction for one-year data, data selection and transfer phase taking long time expected. I have done following to improve the performance but still its running slow and not using all server resources.

1) I am using parallel processing for data selection for large table

2) TDMS server group configured since I have application servers on control/central system

3) DB in NONarchive log mode

4) I have dropped indexes before data transfer starts

5) I am transferring close 2TB data from sender to receiver system

6) Enough batch and dialog process are free on control/central , sender and receiver system

after doing all this, package is running slow, please advise how I can improve the performance. ? Thanks in advanced.

Thanks Atul-

[Sreejith]

Hello Atul,

You seems to have already performed most of the performance improvement techniques.

I would recommend you to upgrade to the latest SP to get the best performance out of the header activities using the new and improved header programs. These programs are part of standard from SP09.

You could also raise an incident with a reference package. We can have a look and see which activity is taking time and recommend the appropriate performance improvement techniques to you.

Thanks,

Sreejith Rajashekaran