Lock request time out Error

• Oracle_91

  SSChampion

  Points: 14548

  More actions

  July 9, 2009 at 3:42 pm

  #95869

  Hi,

  While am expanding the Tables or any node inside the Management Studio, am getting Lock request time out error. in such situations, i normally write a query to get my required output.

  say for example, sp_helptext '<>'

  Instead of going to Object Explorer, expand programmability .. so on.

  Can anybody suggest me a permannat fix for this???

  Also, can anyone figure out why does such error come???

  Pl find the attached screen shot for the error i got.

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  July 9, 2009 at 9:31 pm

  #1022838

  Hello,

  This is possibly caused by high levels of blocking on your SQL Server.

  May be take a look at these articles:-

  http://www.sql-server-performance.com/tips/blocking_p1.aspx

  http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=27354&highlight_key=y&keyword1=error+1222

  Regards,

  John Marsh

  www.sql.lu
  SQL Server Luxembourg User Group

• Oracle_91

  SSChampion

  Points: 14548

  More actions

  July 9, 2009 at 10:22 pm

  #1022846

  Thank You Friend.

• Paul White

  SSC Guru

  Points: 150467

  More actions

  July 10, 2009 at 4:57 am

  #1022944

  This is often caused by a concurrent activity such as an offline index rebuild holding a Sch-M (schema modification) lock on a system table.

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi