Lock request time out period exceeded.

Error:

Msg 1222, Level 16, State 24, Procedure xxxx, Line 79 [Batch Start Line 778]
 Lock request time out period exceeded.

Resolution:

• The query is referencing a database in AlwaysOn and the database is corrupted. Fix the AlwaysOn database.

Error 2:

“lock request time out period exceeded” Error When Trying to See DB Hierarchies.

Resolution 2:

Some process is locking the database. Try to find the process that is locking the database using sp_who2. Also close all connection to the database including the current SSMS session.

Sources:

https://dba.stackexchange.com/questions/23335/lock-request-time-out-period-exceeded-error-when-trying-to-see-db-hierarchies