Home » sql server rebuild index lock request time out period exceeded

sql server rebuild index lock request time out period exceeded

sql server DBA 999

SQL Server Error 1222 lock request time out period exceeded

SQL Server Error 1222 lock request time out period exceeded

 

Lock request time out period exceeded using SSMS in SQL Server

The error message:

lock request time out period exceeded. (microsoft sql server, error: 1222)

SQL Server Error 1222 lock request time out period exceeded is related to the time out of query due to locking of resources in SQL server.

Lock request time out period exceeded. (.Net SqlClient Data Provider) using SQL Server Management Studio.

Why and How to fix:

 

The error message “Lock request timeout period exceeded Error 1222” indicates that a transaction is holding a lock on the target resource … Read the rest