Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Service Broker doubt Expand / Collapse
Author
Message
Posted Thursday, February 7, 2013 11:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 8, 2013 9:54 AM
Points: 13, Visits: 89
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
Posted Thursday, February 7, 2013 12:06 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:00 PM
Points: 31,181, Visits: 15,627
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
Posted Thursday, February 7, 2013 1:24 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 8, 2013 9:54 AM
Points: 13, Visits: 89
Thanks for reply Steve, is all that I wanted to know, have a nice day :)
Post #1417335
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse