Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2014

    Unanswered: SQL Server Tables Are Getting Lock


    We have a project developed on 3.5 with SQL Server 2008 R2 as back end database. One of our client is facing issue of system performance in the afternoon time only. Mostly the tables are getting locked for unlimited time and system gets very slow. Need a professional SQL Server DBA help to identify the root cause.

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 17
    Use the system stored procedure sp_who2 and look at the BlkBy (blocked by) column. Work your way up the blocking chain to identify the update/insert/delete process that is causing all the blocking.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts