Service Broker doubt

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Database Design » Design Ideas and Questions » Service Broker doubt

Service Broker doubt

Rate Topic

Display Mode

Topic Options

Author

Message

Carl0s_

Posted Thursday, February 07, 2013 11:59 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, May 12, 2013 11:03 PM
Points: 13, Visits: 84

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

Post #1417280

Steve Jones - SSC Editor

Posted Thursday, February 07, 2013 12:06 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 1:14 AM
Points: 31,433, Visits: 13,746

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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1417288

Carl0s_

Posted Thursday, February 07, 2013 1:24 PM

Grasshopper

Group: General Forum Members
Last Login: Sunday, May 12, 2013 11:03 PM
Points: 13, Visits: 84

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

Post #1417335

« Prev Topic | Next Topic »

Permissions