Service broker filling up Tempdb

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Programming » Service Broker » Service broker filling up Tempdb

15 posts, Page 2 of 2

««1 2

Service broker filling up Tempdb

Rate Topic

Display Mode

Topic Options

Author

Message

emile.milne

Posted Thursday, October 25, 2012 4:39 AM

Valued 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

emile.milne

Posted Thursday, October 25, 2012 5:00 AM

Valued 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

Nils Gustav Stråbø

Posted Thursday, October 25, 2012 5:07 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 11:01 PM
Points: 1,787, Visits: 3,325

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

Bobby Glover

Posted Monday, October 29, 2012 2:43 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 9:36 AM
Points: 162, Visits: 662

Can two service broker queues use the same contract.

Post #1378471

R.P.Rozema

Posted Monday, November 05, 2012 4:26 AM

SSC-Addicted

Group: General Forum Members
Last Login: Sunday, May 12, 2013 4:01 AM
Points: 406, Visits: 1,364

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 »

15 posts, Page 2 of 2

««1 2

Permissions