How to Gather Statistics on a SQL Server Database

(Doc ID 904287.1)

Last updated on FEBRUARY 27, 2018

Applies to:

Primavera P6 Professional Project Management - Version 7.0 and later
Primavera Contractor - Version 6.1 and later
Primavera P6 Enterprise Project Portfolio 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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms