People working on SQL Server (Either on Data Warehousing or working on OLTP databases) usually face thread locking issues in SQL Server. According to Microsoft Errors like Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222) are caused when “Another transaction held a lock on a required resource longer than this query could wait for it.” i.e. there is another thread or query that is accessing this information and have locked that resource (table).
There are two possible solutions,
The First Solution
The first and the easy solution is to identify that locking (offending) process and then killing that process. But this will Read full story »