SQL Server Performance


Discussion in 'SQL Server 2005 General DBA Questions' started by B5CSE, Nov 29, 2004.

  1. B5CSE New Member

    i want to know what is service broker and what is relation between service broker and sql server
  2. CanadaDBA New Member

    SQL Server Service Broker(SSB) is a new part of the database engine that is used to build reliable, asynchronous, message-based distributed database applications. Service Broker allows these applications to concentrate their development efforts on the issues of the problem domain in which they are going to be used.

    For complete aricle:http://www.sswug.org/see/20619

  3. satya Moderator

    Service Broker is introduced iN SQL server 2005.
    Event notifications differ from triggers by the fact that the actual notification does not execute any code. Instead, information about the event is posted to a SQL Server Service Broker (SSB) service and is placed on a message queue from where it can be read by some other process.

    Check in SQL Server 2005 forum section for further information on enhancements.

    (moved from General DbA section)

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page