Weird things happened lately on one of my SQL Servers:
Select * from Viewnever ends, but the SQL queries inside the view runs well separately.
ALTERprocedure never ends.
DELETEprocedure cause Error:1222, which suggests a lock from something
- Multiple SQL jobs never end once started.(killed manually after run for 3+ days)
I had a feeling that something was not right with the SQL server, so I rebooted the server and everything was fixed.
I still don't know what went wrong. It is like SQL Server wore out. I am wondering if anyone had similar experience or can point me some reading about what happen during the process of rebooting.