Primavera P6 SQL Server database slow loading data, performance issue

When using Primavera P6 with Microsoft SQL Server database, we can have problem like this:

• 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.

Here is the solution to solve above problem:

STEP 1:

Login to SQL Management Studio:

Right click on your database and select New Query:

STEP 2:

Run the following queries to re-gather stats for the ‘PROJECT’ and ‘TASK’ table:

update statistics project with fullscan ,all
update statistics task with fullscan ,all

Press F5 to run it.

STEP 3:

Re-gather stats for all Primavera tables by running the following stored procedure:

exec sp_updatestats

Press F5 to run it

That’s all.

Now your Primavera P6 application should run faster 🙂

UPDATE:

We can run a more thorough commands as below:

STEP 2:

Run this SQL to Generate a Script that will gather stats on all tables::

SELECT 'UPDATE STATISTICS ' + table_name + ' WITH FULLSCAN; ' FROM  INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'

Press F5 to run it.

STEP 3:

Copy and paste the results from Step 2 above into a new query window and execute it (F5).