Question : We have a nice piece of python that sends some emails and interacts with a cloud system. Works […]
Tag: service-broker
How do query notifications detect changes in the query result?
Question : I am working with a legacy database that has implemented query notifications against a table called ColorList. While […]
SQL Server 2008 R2 Service Broker Troubleshooting
Question : I set up Service Broker between two databases on separate instances, one on a 2008 R2 Cluster the […]
Service Broker – Conversation Lifetime?
Question : We are trying to get Service Broker working in our environment in order to solve a business case. […]
Is there a service broker target for an extended event session
Question : We use Service Broker heavily for asynchronous background processing. Additionally we want to use it for extended event […]
Is the Service Broker good for publishing data between servers?
Question : I’m trying to find a better solution when publishing data to a remote table. So we have Server […]
Set TRUSTWORTHY On smacks down service broker from working
Question : I’ve got a database running on a SQL-Server 2012 DBMS. Consider that the server running SQL Server is […]
SQL Server CPU spikes – possibly non-query related – suggested indicators
Question : I’m looking for suggestions for indicators I could monitor to discover what is causing these cpu “blunted spikes”. […]
SQL Server Service Broker and Deadlocks
Question : I am reading through SQL server books online for the first team whilst learning how to use the […]
How do I determine what is activating my SQL service broker proc?
Question : I have several queues. One of which has suddenly started acting oddly. It activates repeatedly while nothing is […]