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 completing.
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?