Project Server 2013 Performance issues due to “Prepare Project Web App Permission Synchronization” job

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

Issue Description:

Project server responds slowly when the following jobs are stuck in Queue.

“Prepare Project Web App Permission Synchronization”

“Prepare Project Web App Permission Synchronization for Projects”

 

Workaround:

Action 1: Open Project Web App, Server Settings and Manage User Sync Settings

 

Disable the following settings

Enable Project Web App Sync

             Enable Project Site Sync

 

Action 2: Add a task in the Task scheduler and schedule the action as below.

Program/Script: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe

Add arguments: c:\path\addperm.ps1

 

Add the following content and create the PS1 file in the above path.

 

Sample PowerShell Script: (modify based on your requirements)

add-pssnapin microsoft.sharepoint.powershell

$site = Get-SPSite http://servername/demo

Write-host "adding Authenticated Users to"

foreach ( $web in $site.allwebs )

{

     if ( $web.HasUniquePerm )

    {

        Write-host `t`t`t $web.url

        New-SPUser -UserAlias "NT AUTHORITY\Authenticated Users" -Web $web.url -PermissionLevel Contribute  | Out-Null

    }

}

More Info: 

Register to get free online tour:

https://secure.projecthosts.com/PB_Registration.asp?PartnerID=300219&LDT=Tour

Contact us:

www.projectmadeeasy.com
info@projectmadeeasy.com