I work with a web application that runs on a SQL database.
We had a few instances of a completely blocked client system and of all users who were experiencing timeouts when trying to access any page of the application.
We have limited the problem to some SQL Broker activities running in the background. We use SQL Broker for a number of asynchronous tasks to perform. When the system was blocked, we were unable to
• Select an item in sys.transmission_queue. The selection with nolock did not help either. It just runs.
• Can not select one of the SQL Broker queues for the database. All turn, even without blocking
• Can not disable SQL_Broker on the database even with an immediate rollback.
Poisonous message error handling is enabled, but the queue has not been disabled when this occurred.