(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
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?
Printer-friendly version
Send to friend
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_admin/helpmain.htm?toc.htm?93131.htm
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.
Email: PPadmin@planningplanet.com
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