Title: [5-day-delivery] Troubleshoot SQL Server Service Broker
Category: 5-day-delivery
Tag(s): SQL Server, Troubleshoot, Service Broker
Description: You want to troubleshoot and fix SQL Server Service Broker.
Common Issue(s)
- Activation stored procedures do not run
- Messages remain on the queue
- Messages remain in the transmission queue
- Route exists, transmission status shows no route for service
- Transmission status shows target service broker unreachable
- Transmission status shows transport layer unavailable
- Transmission status shows "an existing connection was forcibly closed by the remote host"
- Messages are not sent in priority sequence
- Messages are not received in priority sequence
- Messages are not assigned the expected priority level
Management
- Fixed-time: 5 working day(s)
- Fixed-scope: 1 service
- Fixed-price: $500
Work Breakdown
- Troubleshoot Activation Stored Procedures
- Troubleshoot Routing and Message Delivery
- Troubleshoot Conversation Priorities
- Monitoring
Out of Scope
- Root Cause Analysis (RCA)
Deliverable(s)
- The Service Broker should process the messages.
- Recommendations
- Server Level
- Clarification call (up to 1 hour)
Prerequisite(s)
- Database server access
- Screen sharing, if applicable