DeadLocks in SharePoint Content Databases
Hi, For past few days daily at night there was DeadLock occurring in one of the content databases causing sites not accessible and no transaction happening to this content databases. Our database size is 470GB. Tried changing the timing for "Database Statistics" timer job after database backup has completed. But still same issues... Found below tables are being locked and especially dbo.workflow table has 80% of exclusive locks. dbo.alluserdata dbo.sitequota dbo.sites dbo.workflow dbo.workflowassociation Any problem in workflow. We have more workflow records... Any solution to this? Rajini Hasan
February 25th, 2011 2:22am

Check for what kind of workflow you have for the sites. Check for any never ending workflows. View the workflow histry list to see how often items are getting added. Thanks, DipDip
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2011 11:31am

We have many sites. Its very hard to check each sites. SO Is there a way to identify the workflows that got struck or never ending workflows? Rajini Hasan
March 1st, 2011 2:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics