SharePoint Tidbits - Table/Database locks - Troubleshooting steps

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 ( http://blogs.msdn.com/b/grahamk/archive/2008/04/14/performance-problems-in-sql-server-what-data-should-i-collect.aspx )

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