Best Practices for Performance Tuning of the P6 EPPM Database
(Doc ID 1327603.1)
Last updated on JUNE 20, 2024
Applies to:
Primavera P6 Enterprise Project Portfolio Management - Version 6.2.1 and later Primavera P6 Professional Project Management - Version 6.2.1 and later Information in this document applies to any platform.
P6 performance is slow
P6 performance issues
Purpose
The purpose of this document is to provide best practices for performance tuning of a P6 EPPM or P6 Professional database hosted in an on-premise SQL Server or Oracle database platform.
This document applies only to self-hosted P6 environments. By default all required performance-tuning tasks are performed automatically on a recurring schedule for customer databases in Oracle Cloud-hosted environments.
Scope
This document is intended for Database Administrators (DBAs).