Question : I’ve been trying to get this Service Broker and timers thing to work for over a week straight […]
Tag: service-broker
SQL Server, ServicerBroker for asynchronized execution of stored procedures
Question : I followed this tutorial: https://gallery.technet.microsoft.com/scriptcenter/Using-Service-Broker-for-360c961a and it is working for me, However, I don’t understand some thing: At […]
Service Broker: Queue Monitor is dropped after poison message
Question : I have searched everywhere and there isn’t an answer online. There is one similar question on stackoverflow but […]
Drop service hangs indefinitely
Question : I have a mirrored database that was using a service broker to push notifications to a client. The […]
How many connections reads queue
Question : Is there a way to get to know how many external tasks (console applications) is reading queue? I […]
time difference between two machines makes problem in service broker communication
Question : I have two machines and each machine has a SQL Server instance. Between these machines I run service […]
SQL Server Cache Flush and Disk I/O
Question : We’re busy load testing an OLTP system we’ve developed in .NET 4.0 and runs SQL Server 2008 R2 […]
SQL Server Service Broker – CHECKDB found consistency errors, how could this happen?
Question : I encountered a weird SQL Server Service Broker consistency problem, namely I have a queue that holds messages […]
What is the purpose of the database ‘owner’?
Question : Today while troubleshooting a service broker problem, I discovered that the database owner was the Windows login of […]
What is the permission necessary to drop a service in service-broker?
Question : When I want to drop a service which is already created, this error happens: Msg 15151, Level 16, […]