My Oracle Support Banner

How to Gather Statistics on a SQL Server Database (Doc ID 904287.1)

Last updated on JULY 20, 2020

Applies to:

Primavera Contractor - Version 6.1 and later
Primavera P6 Enterprise Project Portfolio Management - Version 7.0 and later
Primavera P6 Professional Project Management - Version 7.0 and later
All Platforms

Goal

The goal of this document is to provide instruction for gathering statistics against a P6 EPPM / P6 PPM SQL Server database.

SQL Server uses statistical information to estimate the number of rows in the query result to be returned, which enables the built-in Query Optimizer to create a high-quality query execution plan.  If the statistics are out of date (due to a large change or accumulated small changes to the data) the Optimizer is using old data which causes inefficient query plans to be run, resulting in slower database performance.

Following list of symptoms can be resolved by gathering statistics:

  • Loading Data hangs at 98%.
  • Performance issues in SQL Server.
  • Opening projects is slow.
  • PM.exe not responding after entering username and password.
  • Project Management window disappears after loading data.
  • Cannot login to PM, no error.

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.