Service Broker

What Does Service Broker Mean?

Service Broker is a feature of SQL Server that monitors the completion of tasks, usually command messages, between two different applications in the database engine. It is responsible for the safe delivery of messages from one end to another. If a target application is temporarily shut down or is not responding, Service Broker stores the messages until they are ready for delivery.

Advertisements

Techopedia Explains Service Broker

When two applications (within or outside of SQL Server) communicate, neither can access the technical details at the opposite end. It is the job of Service Broker to protect sensitive messages and reliably deliver them to the designated location. Service Broker is highly integrated and provides a simple Transact-SQL interface for sending and receiving messages, combined with a set of strong guarantees for message delivery and processing. The initiator program (one that starts the conversation) sends the message to the Service Broker along with the target application (receiver’s) address. The target application, after receiving the message, sends an acknowledgement or response message which indicates the successful delivery of to the indicator application.

Advertisements

Related Terms

Margaret Rouse

Margaret is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages.