Service Broker
E56724
Service Broker is a SQL Server feature that provides native support for reliable, asynchronous messaging and queuing within database applications.
Statements (49)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server feature
ⓘ
messaging framework ⓘ |
| benefit |
decouples application components
ⓘ
improves scalability of database applications ⓘ reduces need for custom messaging infrastructure ⓘ supports long-running workflows ⓘ |
| componentOf |
SQL Server
ⓘ
surface form:
SQL Server Database Engine
|
| configuredBy |
ALTER DATABASE SET ENABLE_BROKER
ⓘ
CREATE CONTRACT statement ⓘ CREATE MESSAGE TYPE statement ⓘ CREATE QUEUE statement ⓘ CREATE ROUTE statement ⓘ CREATE SERVICE statement ⓘ |
| domain | database applications ⓘ |
| implementedAs |
T-SQL DDL and DML statements
ⓘ
database objects ⓘ |
| introducedIn |
SQL Server
ⓘ
surface form:
SQL Server 2005
|
| providedBy |
SQL Server
ⓘ
surface form:
Microsoft SQL Server
|
| purpose | enable reliable, asynchronous messaging within SQL Server databases ⓘ |
| requires |
Service Broker endpoint for cross-instance communication
ⓘ
database master key for dialog security ⓘ |
| supports |
asynchronous messaging
ⓘ
message queuing ⓘ reliable messaging ⓘ |
| supportsFeature |
activation of stored procedures
ⓘ
conversation groups ⓘ dialog security ⓘ distributed applications ⓘ exactly-once-in-order message delivery ⓘ internal and external activation ⓘ message retention in queues ⓘ poison message handling ⓘ routing between SQL Server instances ⓘ routing between databases ⓘ service-oriented database applications ⓘ transactional messaging ⓘ |
| typicalUseCase |
background processing and batch workloads
ⓘ
event-driven database applications ⓘ order processing systems ⓘ |
| uses |
sys.conversation_endpoints system view
ⓘ
sys.service_queues system view ⓘ sys.transmission_queue system view ⓘ |
| usesConcept |
contracts
ⓘ
conversations ⓘ endpoints ⓘ message queues ⓘ message types ⓘ routes ⓘ services ⓘ |
Referenced by (2)
Full triples — surface form annotated when it differs from this entity's canonical label.