Service Broker in SQL Server 2008

In this article we can describe about service broker in SQL server 2008.
  • 1979

Introduction

Service Broker in SQL Server provides a platform on which services are communicated with each other. Services are communicated by sending and receiving the messages. This type of communication is known as Messaged based communication. Sometimes ,The clients have a problem to submit and process the requests if server is not available. For solving this problem we can provide a asynchronous communication between the client and the server. SQL Server allow us to implement asynchronous communication between the client and server by using service broker.

Service Broker allows the database developers to create services that converse with each other by sending and receiving the messages.

The following list represent the Usage of service broker

  1. Reliable query processing
  2. Asynchronous triggers
  3. Reliable data collection
  4. Data consolidation for client applications
  5. Large-scale batch processing
  6. Distributed server-side processing for client applications

Service Broker architecture consists of  the following database objects

  1. Message
  2. Service
  3. Message type
  4. Contract
  5. Queue
  6. Service program

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.