Improved DTS Processing Jobs
DTS has been enhanced to enable the processing of MMDaily jobs on application servers concurrently. This enhancement speeds up the processing time of daily aggregation as all DTS servers are now utilized. The new table DTS_APPSERVER_JOBS provides information about which location has been processed by which server for a particular business date.
Simphony release 2.9 introduced DTS support for parallel processing by threads. You can turn parallel processing on by configuring thread size in the DataTransferService.exe.config file: <add key="MMDailyThreadMax" value="n"/>. The value of n is based on the amount of physical cores and logical cores. For Reporting and Analytics releases prior to 9.0 patch 8, Oracle recommends using half the amount of physical cores + 0.25 of logical cores. For Reporting and Analytics release 9.0 patch 8 and later, Oracle recommends approximately 2/3 the amount of physical and logical cores combined for the number of threads if the new aggregation method is enabled.
Parent topic: Features and Updates