Best ways to speed up P6? It used to be ok, has slowed down. I probably need a new computer, but what are some basic system and program changes to improve performance speed of P6?
Best ways to speed up P6?
Featured Partner
Top Posters
jeoffrey reyes
15 posts
Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Our Partners
Go to start
All programs
Select Microsoft SQL Server 2005
Then Microsoft SQL Server Management Studio
Server name is the name of your computer\PRIMAVERA
Authentication is SQL Server Authentication
Login: sa
Password is: Prima123Vera
Select Connect
On the left expand the databases and select pmdb$primavera
Uptop select New Query
on the right type this
update statistics project with fullscan ,all
update statistics task with fullscan, all
Then right click execute
Then type
exec sp_updatestats
Then right click execute
Hi John,
1. If you are using SQL Server database - P6 PPM
Try running the following query for your database in SQL Server
exec sp_updatestats
then
update statistics project with fullscan ,all
update statistics task with fullscan ,all
https://docs.oracle.com/cd/E80667_01/English/Admin/p6_eppm_database_adm…
2. Also, apparently there is a way to increase the Java virtual machine memory to 4GB in Environment Variables - try at your own risk - it didn't quite work for me btw
To increase the amount of memory available for Java virtual machine and Primavera on Windows operating system please follow these steps:
· Go to Control Panel -> System and Security -> System
· Click on "Advanced system settings"
· Click on "Environment Variables..."
· Under the "System variables" group, please click on the button "New..."
· Enter:
oVariable name: _JAVA_OPTIONS
oVariable value: -Xms4096m -Xmx4096m
· These settings increase Java virtual machine memory to 4GB
3. Perhaps not an option now but for future, use different databases for different portfolios/projects etc.
4. From my experience, you need at least 16GB RAM laptops (with modern processors), 8GB will slow down eventually. Point No. 2 is supposed to utilize the additional RAM but again I didn't see much success. Point No.1 normally provides the most success.
1. work standalone not on a network
2. make sure there is no POBS data in the database
3. make sure that there are not any unecessary risk categories under Admin Categories some have weird symbols
4. Projects that are complete open them up and select file send project and email them to yourself then delted them from the
database
John, if you're working on your own standalone P6 database - try creating a new database and use that. If the speed improves in the new database, then the issue lays with the original DB you were using, possibly its size, or perhaps some corruption. If the speed in the new database is equally bad, then yes, it may mean issues with your PC.