You must understand how data compiles in key tables and how this impacts performance of the usage monitoring process. You can gather audit columns on each table (for example, CREATE_DATE) on a daily basis and from the REFRDEL table. To make hardware decisions, you must monitor the size of the tables and how much the tables grow over several weeks. In addition, you must track the peak usage times.
For P6 EPPM, this includes the following tables:
- PROJECT
- TASK
- TASKACTV
- TASKRSRC
- TASKMEMO
- UDFVALUE
- RSRCHOUR
- PROJWBS
For Primavera Unifier, this includes the following tables:
- SYS_STG_BP_LINE
- SYS_STG_CASH_FLOW
- SYS_STG_CBS_HIER
- SYS_STG_CBS_ROW
- SYS_STG_PROJECT