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 🙂

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