What is Service Broker in SQL Server and is it meaningful to enable it in a simple database, not in a distributed database?
Sql – Service Broker in SQL Server
netservice-brokersqlsql server
Related Topic
- Sql – the difference between “INNER JOIN” and “OUTER JOIN”
- Php – How to prevent SQL injection in PHP
- Sql – Add a column with a default value to an existing table in SQL Server
- Sql-server – How to check if a column exists in a SQL Server table
- Sql-server – Check if table exists in SQL Server
- Sql – How to do an UPDATE statement with JOIN in SQL Server
- Sql – How to UPDATE from a SELECT in SQL Server
- Mysql – How to import an SQL file using the command line in MySQL
Best Answer
SQL Service Broker is an extension mechanism that allows you to queue events for asynchronous processing.
There is no intrinsic harm in enabling the broker. If it's not used, it will just be idle.
It works in both simple and distributed DBs. A simple use case would be a logging queue. We used it at a client to queue XML messages to be processed asynchronously. So we push an XML to an InitatorQueue, and then had a service pull them from the queue, extract some necessary attributes via XPath, and insert them into a persistence table in our database.
Here is a good reference from Microsoft.