Microsoft Entra Suite Tech Accelerator
Aug 14 2024, 07:00 AM - 09:30 AM (PDT)
Microsoft Tech Community
SharePoint Tidbits - Table/Database locks - Troubleshooting steps
Published May 15 2019 03:08 PM 393 Views

First published on TECHNET on May 14, 2013

Hello All,


I don't have all the answers but what we can do is get you started down the correct route to figuring out what is going on.  This is what I recommend you gather when you have a lock that is interrupting users productivity


From SQL:

    1. Name of Proc or Process, and database that are being affected


    1. Gather SQLDiag output using SD_Detailed.XML ( )


    1. Turn on trace flag 1222 and 1204 and collect errorlog.

From SharePoint

    1. Gather ULS logs from each server

Based on this data we should be able to figure out what was happening during the lock, and then put together an action plan to resolve the issue.


I also recommend that ahead of time we set the following Categories under Diagnostic Logging to Verbose

    1. Database


    1. Timer


    1. Timer Job


Version history
Last update:
‎Apr 28 2020 03:02 PM
Updated by: