When developer use SQL Server to create any transaction, sometimes they forget to rollback the transaction with begin transaction statement. It will cause the Timeout for the database as the transaction is still remain open.
The following steps will help you to solve the problem.
Check if any open transaction here: DBCC OPENTRAN
Kill the UId which is open if any with: KILL 80
If you enjoyed reading this, then please explore our other articles below: