Effects of enabling service broker I would like to use SqlCacheDependency to update a dataset in real-time, but we have not enabled the service broker on our production database. Could enabling the service broker have any adverse effects (performance, reliability, etc)?
Most likely Service Broker is enabled in your production database. It is enabled by default, it only gets disabled on restore in order to prevent distributed split-brains scenarios.