How to Gather Statistics on a SQL Server Database
(Doc ID 904287.1)
Last updated on JULY 24, 2023
Applies to:
Primavera Contractor - Version 6.1 and laterPrimavera P6 Enterprise Project Portfolio Management - Version 7.0 and later
Primavera P6 Professional Project Management - Version 7.0 and later
All Platforms
Goal
This document provides instructions for gathering statistics against a P6 EPPM or P6 Professional database hosted on a Microsoft SQL Server platform.
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 and results in slower database performance.
Gathering statistics can potentially resolve the following symptoms:
- Loading Data hangs at 98%.
- Performance issues in SQL Server.
- Opening projects is slow.
- PM.exe is not responding after users enter their login name and password.
- The Project Management window disappears after loading data.
- Users cannot login to P6, with no error displayed.
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 |
| To determine the last time statistics were gathered per index, per table: |
| Gather SQL Server statistics using the recommended method: |
| Gather SQL Server statistics using the full-scan method: |
| References |