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 ««12

Service broker filling up Tempdb Expand / Collapse
Author
Message
Posted Thursday, October 25, 2012 4:39 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:22 AM
Points: 63, Visits: 224
Is it as simple as just giving rid of the ‘with clean up’ or does it need a rewrite as the link suggests as it is a fire and forget from the initiator.
Post #1376901
Posted Thursday, October 25, 2012 5:00 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:22 AM
Points: 63, Visits: 224
Is it as simple as just giving rid of the ‘with clean up’ or does it need a rewrite as the link suggests as it is a fire and forget from the initiator.
Post #1376916
Posted Thursday, October 25, 2012 5:07 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 12:12 AM
Points: 1,854, Visits: 3,450
Impossible to say without testing. Implement this change on a development server and see if it works. That is the only advice I can give without seeing you actual code.
Post #1376922
Posted Monday, October 29, 2012 2:43 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 9, 2013 8:19 AM
Points: 179, Visits: 751
Can two service broker queues use the same contract.
Post #1378471
Posted Monday, November 5, 2012 4:26 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 3:20 AM
Points: 411, Visits: 1,400
Bobby Glover (10/29/2012)
Can two service broker queues use the same contract.

It's services that you connect a contract to, not the queue. When you have a conversation between 2 services in the same database, it is even very likely that 2 queues use the same contract.

So yes, you can re-use the same contract for multiple services.

Also, you can create multiple services connected to one and the same queue. Since each service can have one or more contracts and there doesn't need to be a connection between the contracts on these services, you can also have messages from multiple contracts going into one and the same queue.




Posting Data Etiquette - Jeff Moden
Posting Performance Based Questions - Gail Shaw
Hidden RBAR - Jeff Moden
Cross Tabs and Pivots - Jeff Moden
Catch-all queries - Gail Shaw


If you don't have time to do it right, when will you have time to do it over?
Post #1380971
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse