What is Service Broker?

Question

When n Why should i need/use this?

Manas Mohapatra · Answer

Service Broker is a feature in SQLServer which helps to send and receiving messages from other servers. Means server 1 send messages to server 2 that that job is done and each communication is considered as complete channel of communications(dialog). It helps to build a secure reliable and distributed database architecture. You need to use Service Broker in following scenario like: 1. Asynchronous processing 2. Parallel processing http://searchsqlserver.techtarget.com/tip/Service-Broker-in-SQL-Server-How-and-when-to-use-it Go through below links to get more ideas: http://www.databasejournal.com/features/mssql/article.php/3880191/SQL-Server-Service-Broker---An-Introduction.htm https://technet.microsoft.com/en-us/library/ms166049(v=sql.105).aspx https://www.mssqltips.com/sqlservertip/1836/sql-server-service-broker-example-on-how-to-configure-send-and-receive-messages/