| Performance and finetuning |  |
| This section describes how you can optimize the performance of the Data Upgrade Engine ( DUE ). The performance of the DUE is influenced by: The runtime class of the upgrade tasks The usage of additional servers The usage of the local server for processing Runtime class During initialization of the DUE run, the upgrade programs determine their runtime class. This is based on factors such as parameter settings, table sizes, and source feature pack. Common rules are used. For your specific environment there may be factors that lead to a not optimal determination of the runtime class. As a result long running tasks may be scheduled later than small tasks. This causes a longer total elapsed time. We recommend to perform a test upgrade run before you start the real run. You can analyze the results of the test run, and optimize the running class where necessary. Complete these steps: Perform a test run. See Executing a data upgrade run. For a realistic test, perform this test run on companies that are copied from the real live data companies. Print and analyze the results of the test run. Start the Print Data Upgrade Run Information (ttspt2400m000) session. Select the Data Upgrade Run Information [Flat File] report and print the data of the test run to a file. Optionally, import this file in MS Excel. Analyze the results. Per upgrade task, view the runtime class and the duration. Optimize the running class in these situations: A task, which lasts long, has a low running class. Select a higher running class for the task. A task, which takes a short time, has a high running class. Select a lower running class for the task. For example: A task has running class Medium and lasts 3 hours. Change the running class to Large or Huge. A task has running class Huge and lasts only 30 minutes. Change the running class to Large or Medium. Other tasks will take advantage of this. The duration of an upgrade task differs per company because it depends on many variables. Therefore, for each company or set of companies, it is important to investigate the maximum duration of an upgrade task before you change the runtime class. Additional servers In the Number of Additional Servers field in the Data Upgrade Engine (ttspt2201m000) session, you can specify the number of additional bshells that will be used to run the Data Upgrade Engine. Additional bshells can greatly improve the performance of the DUE because several upgrade tasks can be started in parallel. Important! If the whole system capacity can be used for the DUE, we recommend to specify one additional bshell per CPU. For example, if your ERP LN server contains 8 CPUs, specify 8 additional bshells. The DUE is very high CPU intensive and other users are hampered when the number of additional upgrade tasks is too high. Therefore reduce the number of additional bshells if not the whole system can be used for the DUE. The additional bshells perform a lot of I/O actions. It is not recommended to add more bshells than the I/O subsystem can handle. If you do not know the I/O capacity of the I/O sub system, as a rule of thumb, specify one additional bshell per CPU. Note If you set the Number of Additional Servers field to 0, the DUE is run in a single bshell. Use the local server for processing When you use additional bshells, the local bshell , where the Data Upgrade Engine (ttspt2201m000) session is started, schedules the upgrade tasks. This local bshell gathers the list of upgrade programs that must be executed and spreads the work over the different bshells. If you select the Use the local Server for processing check box in the Data Upgrade Engine (ttspt2201m000) session, the local bshell will not only schedule the upgrade tasks but will also run upgrade tasks. We recommend the following: Select the Use the local Server for processing check box if you select 1 additional bshell in the Number of Additional Servers field. Clear the Use the local Server for processing check box if you select more than 1 additional bshell in the Number of Additional Servers field. The local bshell only schedules the upgrade tasks. If the local bshell also had to run upgrade tasks, it might be too busy to schedule tasks for the different additional bshells in time. Related topics Data Upgrade Engine overview Executing a data upgrade run |