Hello @RobertoCervantes
This happens because of bad query design. There shouldn't be any query that runs for 2 hours. I would look at Adobe Control Panel to see which query is running what data it is querying. I would first kill the PID associated with the query so that it is not creating deadloc...