P6 EPPM Quantity Info Test

Oracle Primevera uses P6 database to store the projects and related information and is able to handle very large number of projects. For P6 EPPM to perform optimally there should be appropriate hardware available to support the quantity of data and activity on P6 database, application and job servers. Administrators need to know how many projects have been stored in the database, how many new projects have been created recently, what is the number of users, what is the number of concurrent users etc. This will allow the administrators to plan data and compute capacity accordingly. For example if current deployment is going to support very small number of projects only, administrators will configure only one server and small database instance to support the same. On the other hand if the deployment is supposed to service a large number of teams across the regions and very large number of users and activity, it should be on proper cluster of application and database servers to scale an handle the load.

This test measures the key indicators of load on the system and reports metrics like number of projects, users, resources etc. which help administrators plan and provision capacity.

Target of the test : An Oracle Primavera P6 EPPM Server

Agent deploying the test : An internal/external agent

Outputs of the test : One set of results for P6 EPPM Server

Configurable parameters for the test
Parameter Description

Test period

How often should the test be executed.


The host for which the test is to be configured.


The port number at which the specified host listens. By default, this is NULL.

JMX Remote Port

Specify the port at which the JMX listens for requests from remote hosts. Ensure that you specify the same port that you configured in the management.properties file in the <JAVA_HOME>\jre\lib\management folder used by the target application Java Applications chapter.

JMX UserName and JMX Password

If JMX requires authentication only (but no security), then ensure that the User and Password parameters are configured with the credentials of a user with read-write access to JMX. To know how to create this user, refer to the Java Applications chapter. Confirm the password by retyping it in the Confirm Password text box

Confirm Password

Confirm the password by retyping it here.

DD Frequency

Refers to the frequency with which detailed diagnosis measures are to be generated for this test. The default is 1:1. This indicates that, by default, detailed measures will be generated every time this test runs, and also every time the test detects a problem. You can modify this frequency, if you so desire. Also, if you intend to disable the detailed diagnosis capability for this test, you can do so by specifying none against DD frequency.

Detailed Diagnosis

To make diagnosis more efficient and accurate, the eG Enterprise embeds an optional detailed diagnostic capability. With this capability, the eG agents can be configured to run detailed, more elaborate tests as and when specific problems are detected. To enable the detailed diagnosis capability of this test for a particular server, choose the On option. To disable the capability, click on the Off option.

The option to selectively enable/disable the detailed diagnosis capability will be available only if the following conditions are fulfilled:

  • The eG manager license should allow the detailed diagnosis capability
  • Both the normal and abnormal frequencies configured for the detailed diagnosis measures should not be 0
Measurements made by the test
Measurement Description Measurement Unit Interpretation


Indicates the count of total projects stored in P6 database


Large number of projects means more load on database as well as application and Job Servers. Administrators have to look at this number and plan capacity accordingly.

Project codes created recently

Indicates the number of project codes created during last specified number of days.


If large number of projects are being created recently means administrators may expect enhanced activity in upcoming days.

Recent project code assignments

Indicates the number of project codes assigned during last specified number of days.


If the project codes and also assigned, that means users have started working on newly created projects. Administrators may need to add more capacity.


Indicates the total number of activities across all the projects currently active in P6 database.


Activities is the smallest unit in P6, more the activities means more work is being done.

Recent activity codes

Indicates the number of activitycodes created during last specified number of days.


If lot of projects and activities are being created and assigned , it means that lot of data is going to be created and lot more compute capacity is going to be required. You can take a call looking at existing capacity if this will suffice or more capacity is required to support enhanced activities.



Recent activity codes assignments

Indicates the number of activity codes assigned during last specified number of days.


Recent activity resource assignments

Indicates the number of resource assigned to activity codes in last specified number of days.



Indicates the total number of users across all projects currently in P6 database.


Administrators have to plan the server capacity to respond to user requests in timely manner. large number of users can bring down the system even if number of projects is less.

Number of user defined fields

Indicates the number of additional fields created by users apart from existing standard fields.


P6 provides functionality for users to define their own fields, but if the number of these fields is very high it can create aberration in capacity planning.