Share this page

# Task 4: Creating Time Sheets on the TEST Instance to Evaluate Performance

When all of the`.xml`files representing actual data seem to be ready to import, we recommend running the script on the TEST instance against a subset of the actual time sheet data to be imported later on the production instance. This subset should be large enough to evaluate the CPU resource demand of the script and to determine an optimal number of threads for the script to use.

Before proceeding, make sure that the database is correctly configured and sized to accommodate the time sheet data to be imported. Also see Configuring PPM Environments.

Note: If performance of the script does not meet the required throughput with higher values of the `-maxThreadcount` argument, you can run multiple concurrent executions of the script, each against different sets of `.xml` data. Using this approach, the CPU demand is a function of the combination of active threads among all of the script executions.

To test a subset of the`.xml`files representing actual data:

1. Save the subset of the `.xml` files in the desired directory on the TEST instance.

2. Run the script on the TEST instance without using test mode. See Run the Time Sheet Data Importer Script.

   While the script is running, monitor the following:

   - Usage of system resources (CPU, memory, disk space)

   - Table space available in the database

3. When the script completes, review and correct all errors, as in step 4 in Task 1 and step 5 in Task 1.

4. As needed, rerun the script with various values of the `-maxThreadcount` argument to identify the optimal value to use from a performance standpoint.

5. Starting at step 2, repeatedly run the script against corrected source `.xml` files until all errors in the files are corrected, that is, until the script moves all of the `.xml` files to the `SUCCESS` subdirectory.

   When all the `.xml` files chosen for this procedure are in the `SUCCESS` subdirectory, testing on the TEST instance is complete.

6. Cancel the time sheets that were created for test purposes.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: