How to Gather Statistics on a SQL Server Database
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
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.
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