Home Forums Programming Service Broker BRKR TASK consuming large amount of CPU, but Service Broker is not enabled RE: BRKR TASK consuming large amount of CPU, but Service Broker is not enabled

  • When you enable Service Broker you are enabling it for User processes. The End Points you set up are User end points. It is always enabled for System processes and the System end points are not shown to mere humans.

    The same concept applies to CLR. Enabling CLR means enabling it for User processes. Many system processes use CLR and the use of CLR for these cannot be turned off or on. (OK, the SQL authors probably have a way of turning service Broker or CLR off for system processes but the rest of us do not.)

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara