Enable SQL Server Broker taking too long

November 18, 2022 by Tarik

How long should I expect ALTER DATABASE … SET ENABLE_BROKER to run?

alter database [<dbname>] set enable_broker with rollback immediate;