MSSQLSERVER_1222
Details
Product Name |
SQL Server |
Product Version |
10.0 |
Product Build Number |
10 |
Event ID |
1222 |
Event Source |
MSSQLSERVER |
Component |
SQLEngine |
Symbolic Name |
LK_TIMEOUT |
Message Text |
Lock request time out period exceeded. |
Explanation
Another transaction held a lock on a required resource longer than this query could wait for it.
User Action
Perform the following tasks to alleviate the problem:
Locate the transaction that is holding the lock on the required resource, if possible. Use sys.dm_os_waiting_tasks and sys.dm_tran_locks dynamic management views.
If the transaction is still holding the lock, terminate that transaction if appropriate.
Execute the query again.
If this error occurs frequently change the lock time-out period or modify the offending transactions so that they hold the lock for less time.