What to do if the lock request time out period exceeded?
I'm having problems with a database. I can run basic queries, albeit much slower than normal.
When I attempt to view the hierarchy trees for tables, views, or procedures in SSMS Object Explorer, I get lock request time out period exceeded.
My SSRS reports that run on objects in this database are no longer completed. Jobs associated with procedures stored on this database also do not run. I tried using sp_who2 to find and kill all connections on the database, however this has not solved the problem.
What is going on here? How can I resolve this?
If lock request time out period exceeded -
Excluding Hardware consideration, perhaps you need to run the script to check what is the activity withholding the SQL Session, one of the common scenarios is not to use an Implicit transactions Option in SQL Server Management Studio.