SQL Server Service Broker is a messaging framework built into SQL Server. It includes infrastructure for asynchronous programming that can be used for applications within a single database or a single instance as well as for distributed applications.
Questions tagged [service-broker]
576 questions
6
votes
2 answers
Make Service Broker Be Less Aggressive About Detecting Poison Messages?
Sql Service Broker uses the following heuristic to determine when you have messages in your queue that are preventing your application from doing any useful work:
"Service Broker provides automatic poison message detection. When a transaction that…
Chris
- 9,986
- 8
- 48
- 56
6
votes
1 answer
Sql Server Service Broker - thorough, in-use example of externally activated console app
I need some guidance from anyone who has deployed a real-world, in-production application that uses the Sql Server Service Broker external activation mechanism (via the Service Broker External Activator from the Feature Pack).
Current mindset:
My…
Stefan Anghel
- 194
- 3
- 15
6
votes
1 answer
Is it possible to access SQL Server Service Broker from a C# app?
I want to use the SQL Server Service Broker to generate a message (inside SQL Server) and for it to be read in an external C# app.
I am limited to Windows 2003 running SQL Server 2005. I've read a bunch of articles, that allude to this being a…
AngryHacker
- 59,598
- 102
- 325
- 594
5
votes
2 answers
Service Broker only receiving one message at a time
Even when I specify Receive Top(25), etc I am only getting one message to be dequeued at a time. Not sure what i am doing wrong inside my sproc? Probably something trivial, but I don't see the problem.
Sproc:
CREATE PROCEDURE…
scarpacci
- 8,957
- 16
- 79
- 144
5
votes
3 answers
Requirement for a Master Key for Service Broker
I have read in various MSDN pages and SQL Server blogs that "usually" a Master Key is required in a Service Broker database.
Indeed, when trying to RECEIVE messages I get the following application event log message:
Service Broker needs to access…
Emmanuel
- 3,475
- 6
- 29
- 45
5
votes
2 answers
Can I use SqlDependency with multiple listeners / load balance
I am currently using a SqlDependency with a SQL Server 2012 Service Broker and I want to be able to have two servers configured both listening to the service broker and pull off the queue but message should only be pulled off the queue once total.…
Smeiff
- 259
- 1
- 6
- 17
5
votes
1 answer
Untrusted security context in signed activated procedure
I have an activated procedure for a service broker queue that queries a linked server. I have signed the procedure using the method found here. However, I continuously see the following message in the sql server logs:
The activated proc…
Mansfield
- 14,445
- 18
- 76
- 112
5
votes
1 answer
Detect SQL database changes
Consider this example:
INSERT INTO [Table] (column1)
SELECT value1
If I were to execute this command in SSMS, in regards to a c# forms application, what would I need to do in order to recognize this event? Something as simple as the application…
Volearix
- 1,573
- 3
- 23
- 49
5
votes
0 answers
SQLNotificationRequest Application Example or Tutorial
After using SQLDepdendency as a queue implementation in one of my projects (now live) and after discovering that it is ineherinitley broken (see http://rusanu.com/2008/01/04/sqldependencyonchange-callback-timing/).
I am desperately looking for…
gorillapower
- 450
- 6
- 15
5
votes
3 answers
Error : When Using SqlDependency Without Providing an Options Value
I am working on query notification. I have created Queue, Service and Route in my Database. I am accessing my Database on Network by IP Address, so i created a Route in Sql Server like this..
ALTER ROUTE [NotificationMessagesRoute]
WITH …
Shahid Iqbal
- 2,095
- 8
- 31
- 51
5
votes
3 answers
Service Broker messages start to get hung up after about a day
I have an application that is using the Service Broker is SQL 2008. About once a day the database's performance starts take a noticeable hit and I have determined that this is because of the Service Broker. If I hard reset all broker connections…
lehn0058
- 19,977
- 15
- 69
- 109
5
votes
2 answers
Why do I need two SQL Server Service Broker queues for a simple task?
All examples I find on the web for using SQL Server Service Broker queues seem to have two queues. I don't understand why and every example seems to assume that this is so obvious as to be unnecessary to explain.
Several things will write to my…
cja
- 9,512
- 21
- 75
- 129
5
votes
1 answer
Schedule service broker to receive messages automatically
I am new to Sql Server Service Broker and experimenting with it.
I was able to send messages from one DB and receive those messages in another DB (of the same SQL server) and I am inserting those messages into a table in the receiving DB.
Everything…
kthiagar
- 395
- 1
- 3
- 8
5
votes
1 answer
Service Broker and WCF interoperability
Does SQL Server Service Broker have an ability to communicate with a WCF service? I wanna create a Service Broker service which will send some xml message to WCF service for processing. Of course SQL Server instance and WCF service are deployed on…
Marian Zagoruiko
- 1,527
- 3
- 17
- 29
5
votes
1 answer
Service Broker leaving closed items in sys.conversation_endpoints after 30 mins
I have a single machine service broker set up using internal activation, the broker is processing items that are placed on the queue and appears to be closing the conversations correctly (see profile details below).
A single record left in…
Nathan
- 931
- 1
- 12
- 26