I inspect Service Broker Queue Count through queue and internal-table catalogs. A customer requested a quick inventory.
SQL SERVER – Error 15580 – Cannot Drop Master Key Because Dialog “GUID” is Encrypted by It
In this blog, I would share my knowledge about how to fix error 15580 – Cannot drop the master key because dialog “GUID” is encrypted by it.
sysxmitqueue in msdb: Why It Grows and How to Clear It
Sysxmitqueue in msdb fills up when Service Broker messages cannot leave the server. A tested demo in its own database shows the pile, the reason, a one conversation cleanup and the NEW_BROKER reset. The msdb steps follow the same order.
MSDB Growth From queue_messages: How to Clear the Queue
MSDB growth from the queue_messages tables means a Service Broker queue holds messages that nobody reads. This post builds a queue with unread messages in a test database, finds it with a size query, ends only its conversations with the CLEANUP option, and watches the space come back. It also says why you should never end every conversation in msdb.
Post-Restore Checklist: Owner, Trustworthy, Broker and Users
The restore finished with no errors, yet the app cannot connect. Here are the four settings a restore quietly changes, and how to fix them.
SQL SERVER – Service Broker and CAP_CPU_PERCENT – Limiting SQL Server Instances to CPU Usage
Jeff said my Resource Governor script did not limit CPU at all. After a few emails we found why, and how CAP_CPU_PERCENT really limits CPU usage.
SQL SERVER – Introduction to Service Broker and Sample Script
Here is my introduction to Service Broker and sample script: messaging and queuing between instances, conversations and dialogs in SQL Server 2005.