Msg 1222, Level 16, State 24, Procedure xxxx, Line 79 [Batch Start Line 778]
Lock request time out period exceeded.
- The query is referencing a database in AlwaysOn and the database is corrupted. Fix the AlwaysOn database.
“lock request time out period exceeded” Error When Trying to See DB Hierarchies.
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.