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:

Primavera P6 SQL Server database slow performance-1

Right click on your database and select New Query:

Primavera P6 SQL Server database slow performance-2

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.

Primavera P6 SQL Server database slow performance-3

STEP 3:

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

exec sp_updatestats

Press F5 to run it

Primavera P6 SQL Server database slow performance-4

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.

Primavera P6 SQL Server database slow loading data, performance issue-10

STEP 3:

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

Primavera P6 SQL Server database slow loading data, performance issue-11

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a website or blog at WordPress.com

Up ↑