locked
DeadLocks in SharePoint Content Databases RRS feed

  • Question

  • 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
    Friday, February 25, 2011 7:20 AM

All replies

  • 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,
    Dip


    Dip
    http://dzeee.net/sharepoint
    Saturday, February 26, 2011 4:28 PM
  • 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
    Tuesday, March 1, 2011 7:38 AM