My P6 is very slow

IMAGE DELETED 5/11/2018 AS NO LONGER AVAILABLE ON THIS VERY OLD DISCUSSION THAT FOR SOME REASON WAS RESURRECTED AFTER BEING INACTIVE FOR SIX YEARS.Make sure you have a backup of your database before it is too late.Suggest calling ORACLE support team, they are very capable professionals that can guide you to a solution, I suppose although not obvious it shall be an easy solution as P6 is famous for its ease of use, so easy it is their favorite sales pitch.Best regards,Rafael

do thisGo to startAll programsSelect Microsoft SQL Server 2005Then Microsoft SQL Server Management StudioServer name is the name of your computer\PRIMAVERAAuthentication is SQL Server AuthenticationLogin: saPassword is: Prima123VeraSelect ConnectOn the left expand the databases and select pmdb$primaveraUptop select New Queryon the right type thisupdate statistics project with fullscan ,all
update statistics task with fullscan, allThen right click executeThen typeexec sp_updatestatsThen right click execute

Hi,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:<a href="https://doduykhuong.com/2018/05/10/primavera-p6-sql-server-database-slo…;

Hosam,
&nbsp;To solve your problem, try clicking on the link to the right of your question titled, “P6 locks up or is very slow when loading schedule.”&nbsp; Good luck!

Hosam,Delete old files you do not use anymore. Back them up and delete (just in case you need them for reference in the future)Always keep your database lean to keep it running smoothly.Regards,Daniel