One of my customer contacted me and stated that Project server stopped responding and resources were experiencing
extremely slow response. When the resource opens Project / resource center, it
takes enormous amount of time to load the data. When I started digging, observed that the issue
started after they performed a small tweak in the Project Server permission
settings. I.e. Since stake holders wanted everybody in the system should be
able to access all the Project sites in the PWA instance, modified the security
settings to meet the business goal.
Since then on every project publish, project application service started
consuming most of the CPU and memory from the server and stopped responding to
the resource queries.
To meet the goal, scheduled a PowerShell script in the task scheduler to
add the required resources into the Project Sites
Project server responds slowly when the following jobs
are stuck in Queue.
Project Web App Permission Synchronization”
“Prepare Project Web App Permission Synchronization for
Action 1: Open
Project Web App, Server Settings and Manage User Sync Settings
Disable the following settings
Project Web App Sync
Project Site Sync
Action 2: Add
a task in the Task scheduler and schedule the action as below.