Geek Answers Handbook

What is Service Broker in SQL Server?

What is Service Broker in SQL Server and does it make sense to include it in a simple database rather than in a distributed database?

+5
source share
3 answers

SQL Service broker is an extension mechanism that allows queuing events for asynchronous processing.

there is no harm to include a broker, if it is not used, it will simply be inactive.

It works in both simple and distributed databases. A simple use case would be a registration queue. We used it on the client to send xml messages processed asynchronously. Thus, we push xml into the InitatorQueue, and then force the service to pull them out of the queue, extract some necessary attributes via xpath and paste them into the save table in our database.

Here is a good link

+8
source

Service Broker is a messaging system built into the SQL Server SQL engine. Here are some articles you can read to see how this works.


Service Broker
Service Broker

+4

Service Broker - . . - . . SQL Server , .

. , .

+2

More articles:


All Articles