Database Server Locked

• MegaDBA

  Hall of Fame

  Points: 3518

  More actions

  August 5, 2003 at 7:30 am

  #160609

  When I try to remotely come into the server and view current activity or view possible locking, I get a time out error 1222. Any one know what this is and how I can get out of it?

  Thanks

  
  

  Aurora

• mathurar

  Old Hand

  Points: 358

  More actions

  August 5, 2003 at 10:05 am

  #468693

  You have lot more locks than the server can handle.

  Start SQL Query Analyzer, run a query that gives you the list of processes locking each other and kill the one causing grief.

  A sample query is as follows:

  USE MASTER

  GO

  SELECT * FROM SYSPROCESSES WHERE SPID IN

  (SELECT SPID FROM SYSLOCKS) ORDER BY BLOCKED DESC, SPID

  and use:

  KILL <SPID>

  to kill the process blocking others.