Viewing 2 posts - 1 through 2 (of 2 total)
To rule out servicebroker
Query to see is servicebroker is enabled:
SELECT is_broker_enabled FROM sys.databases WHERE name = 'DatabaseName'
If it is check to see if there are any unclosed coversations(run against the...
March 11, 2011 at 9:56 am
#1297758
I had a similar issue last year , 15-20 min in recovery ever time there was a fail over or a restart of sql and it was taking longer each...
March 11, 2011 at 5:48 am
#1297557