| title | MSSQLSERVER_1222 | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/06/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | supportability | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | c5b1c2f4-f591-4cc1-aa17-204636a27f29 | |
| author | MashaMSFT | |
| ms.author | mathoma | |
| manager | craigg |
| Product Name | SQL Server |
| Event ID | 1222 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Symbolic Name | LK_TIMEOUT |
| Message Text | Lock request time out period exceeded. |
Another transaction held a lock on a required resource longer than this query could wait for it.
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.