We are trying to move a large Sharepoint site 60 GB from one content database to another :: but Move-spsite is failing becuase of the database deadlock at source content database level on below stored procedures . It looks like some in progress workflow in caisng the problem.
Below are the 3 stored procedure where we are seeing the deadlocks.
- dbo.ScheduledWorkItems
- dbo.proc_GetRunnableWorkItems
- dbo.proc_DeleteInProgressWorkItems
Questions i have :
1. How can we avoid suck deadlocks at content database level while using the move-spsite .
2. Is there any way, we can pause all the "in progress" nintex workflows before using move-spsite and resume them once the Site is moved to new content database,
