Post reply

Service Broker doubt

  • February 7, 2013 at 11:59 am

    #273915

    Hi,

    Can someone tell me if can I activate Service Broker on a database and doesn't use this feature for some (or long) time?

    Can I get bad performance on my database?

    I mean, I'm learning about SB (Service Broker) and I want to implement, but I can´t for now, because I don't know how to do it. I want to leave database ready for use this feature when I understand how to implement properly.

    I ask this, because some created databases show an error msg when I try to activate SB after structure is created, but if I create again the databases and activate SB before to create all structure (tables and relationships) I dont have problems to activate.

    I will try to implement this feature for take an history of movements in my database and audit.

    Thanks in advance for help 🙂

  • February 7, 2013 at 12:06 pm

    #1585613

    It depends what you mean by activate. Just turn it on, no. If you enable queues and something puts data in them, then it could affect performance if the queues are not being processed.

  • February 7, 2013 at 1:24 pm

    #1585652

    Thanks for reply Steve, is all that I wanted to know, have a nice day 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply