provides the infrastructure for queue-based asynchronous message communication between databases.
Questions tagged [service-broker]
164 questions
57
votes
2 answers
What is the purpose of the database 'owner'?
Today while troubleshooting a service broker problem, I discovered that the database owner was the Windows login of an employee who had left the company. His login had been removed and thus the query notifications were failing.
Supposedly the best…
8kb
- 2,639
- 2
- 32
- 36
20
votes
1 answer
Service broker was backed up, now receiving, but doesn't seem to be processing
Having a problem with Event Notifications. On the machine/drive/database that the messages are sent to (receiver), the drive filled up when nobody was looking, so it's been backed up all day.
Now that we freed up space on the drive, it's…
mbourgon
- 433
- 3
- 10
17
votes
2 answers
Does firing off an indefinite WAITFOR increase the log file size?
In the last release of my app, I added a command that tells it to wait when something arrives in the Service Broker queue:
WAITFOR (RECEIVE CONVERT(int, message_body) AS Message FROM MyQueue)
The DBAs tell me that since the addition, the log sizes…
AngryHacker
- 1,961
- 5
- 22
- 33
16
votes
3 answers
Where to learn SQL Server Service Broker?
Are there any good resources to learn Service Broker?
I'm looking for a newbie-friendly guide.
user6426
12
votes
1 answer
Service Broker - Conversation Lifetime?
We are trying to get Service Broker working in our environment in order to solve a business case. I don't know if the message title is a good one, but my question is below. But it may not be a good question, so after that is what we are doing and…
Jonathan Fite
- 9,414
- 1
- 25
- 30
12
votes
1 answer
Activity Monitor showing long duration for WAITFOR RECEIVE
In Activity Monitor, the following query is causing high CPU and 281ms average duration.
WAITFOR (
RECEIVE conversation_handle
, service_contract_name
, message_type_name
, message_body
FROM ExternalMailQueue
INTO @msgs
)
, TIMEOUT…
SQLLogic
- 121
- 1
- 1
- 3
11
votes
1 answer
Sch-M WAIT blocks Sch-S in SQL Server 2014 but not SQL Server 2008 R2?
We recently migrated our production instances from SQL 2008 R2 to brand new SQL 2014 servers. Here is an interesting scenario that we uncovered with our usage of Service Broker. Consider a database with Broker Enabled = true with MyService and…
Joseph Daigle
- 532
- 1
- 6
- 12
11
votes
1 answer
SQL Server Cache Flush and Disk I/O
We're busy load testing an OLTP system we've developed in .NET 4.0 and runs SQL Server 2008 R2 in the back. The system uses SQL Server Service Broker queues, which are very performant, but we are experiencing a peculiar trend whilst processing.
SQL…
André Haupt
- 275
- 1
- 2
- 8
11
votes
2 answers
Set TRUSTWORTHY On smacks down service broker from working
I've got a database running on a SQL-Server 2012 DBMS. Consider that the server running SQL Server is not part of the network domain.
When I execute this sql command
ALTER DATABASE myDatabase SET TRUSTWORTHY ON;
a service broker queue (early setted…
zappasan
- 113
- 1
- 1
- 6
10
votes
3 answers
Launching a python script from an insert trigger
We have a nice piece of python that sends some emails and interacts with a cloud system. Works fine. But we have to fire it every few minutes to poll the db. We really need, for business purposes, to have the python script fire in real time, so…
Jonesome Reinstate Monica
- 3,489
- 10
- 40
- 57
10
votes
3 answers
The Service Broker endpoint is in disabled or stopped state - AoAG - SQL Server 2012 - 15 minute interval
I receive this error message in SQL Server error log every 15 minutes. I have setup AOAG on this server. The database option "Service Broker - Broker Enabled" is turned on for the Blackberry related databases and MSDB databases on this instance.…
Debbie
- 303
- 2
- 4
- 12
8
votes
1 answer
Error: 9245, Severity: 16, State: 1. / During the last time interval XXX query notification errors were suppressed
I've got this sequence of error messages showing up regularly in my server error log:
Error: 9245, Severity: 16, State: 1.
During the last time interval 257 query notification errors were suppressed.
But I cannot find any specifics on Error…
Kevin
- 306
- 1
- 2
- 9
8
votes
0 answers
SQL Server 2012+ & Service Broker: SSBDT Spam ending conversations after sending message to NULL conversation_handle
I'm mostly posting this for community awareness, but feel free to give feedback if you think there is a solution other than coding around the problem as we are doing. Crossposting this from my bug submission here:…
G.Smith
- 123
- 10
8
votes
1 answer
Service Broker: Queue Monitor is dropped after poison message
I have searched everywhere and there isn't an answer online. There is one similar question on stackoverflow but it's not exactly the same and it has no accepted answer.
When I setup event notification on a queue, it creates a queue monitor and if…
Sergey
- 131
- 3
7
votes
1 answer
Recommendations on how to organize Queues in Service Broker
I have a service broker application that currently has 5 or 6 queues on two servers.
The general workflow is:
Server A
User populates some tables
User fires stored proc which puts a message into a header queue indicating there is work to be…
JNK
- 18,064
- 6
- 63
- 98