Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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)?

share|improve this question

migrated from stackoverflow.com Mar 12 '13 at 14:27

This question came from our site for professional and enthusiast programmers.

1 Answer 1

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.

share|improve this answer
    
And what if they actually did disable it? Conversely, is there any advantage to disabling it if it's not being used? –  Jon Seigel Mar 12 '13 at 17:12
    
@JonSeigel: Basically, no, there is no advantage in disabling it. Unless you explicitly want to prevent its usage (for whatever reason) having it enabled and not used is basically 0 cost. –  Remus Rusanu Mar 12 '13 at 17:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.