Locking Issues

• Bhushan Kalla

  Default port

  Points: 1475

  More actions

  January 20, 2006 at 12:42 pm

  #188926

  Hi Everyone,

  I have few issues with table locks while executing queries and stored procedures. Though the queiries have just select statements with nolock option and stored procedures with "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED" option still I have serious problems with table locks. Specially stored procedures are awaiting long time to recompile while tables are locked and that caused time outs of my queries which is 30 seconds in my application. I would really appreciate if anyone can share your knowledge or insight on this topic. If you can send me any documentation or links about "stop table locks" while executing select queries and "stop recompilation of stored procedures".

   

  Thanks,

  Bhushan

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  January 20, 2006 at 2:53 pm

  #616231

  I wrote an article on stored procedure recompilation:

  Stored Procedures and Caching

  Microsoft's article on how to troubleshoot blocking problems:

  INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems

  K. Brian Kelley
  @kbriankelley