Our production database upgrade from SQL Server 2008 R2 to SQL Server 2012 SP1 recently.
And the active tasks are still increasing, we have 690000 active tasks now.
find that many error message:
Date 8/18/2013 7:01:11 PM
Log SQL Server (Current - 8/18/2013 7:16:00 PM)
An error occurred in Service Broker internal activation while trying to scan the user queue 'Queue Name' for its status. Error: 1222, State: 51. Lock request time out period exceeded. This is an informational message only. No user action is required.