Topic lessonTopic: Applied GitHub Actions and SQL Server recovery labs
Distributed trace exercise|Parallel SQL Server waits
Parallel spans do not add up to elapsed duration. Missing intervals leave causal evidence incomplete.
Compare completion waits for two spans starting together.
The cases use fictional inputs.
What to predict
Parallel spans do not add up to elapsed duration. Missing intervals leave causal evidence incomplete.
- SQL Server span (ms) → Parallel read span (ms)Align conditions
- Parallel read span (ms) → Both span records availableCompare outcomes
- Both span records available → DecisionVerify the decision
- SQL Server span (ms)
- 80 / 220
- Parallel read span (ms)
- 150 / 260
- Both span records available
- Yes / No
- Decision
- Compare completion waits for two spans starting together.
Compare the cases
| Case | Conditions | Decision |
|---|---|---|
| Trial 1 | SQL Server span (ms) 80, Parallel read span (ms) 150, Both span records available Yes | Completion wait: 150 ms. The span sum of 230 ms includes overlap. |
| Trial 2 | SQL Server span (ms) 220, Parallel read span (ms) 150, Both span records available Yes | Completion wait: 220 ms. The span sum of 370 ms includes overlap. |
| Trial 3 | SQL Server span (ms) 80, Parallel read span (ms) 150, Both span records available No | An interval is missing. Hold the decision until another source establishes it. |
| Trial 4 | SQL Server span (ms) 80, Parallel read span (ms) 260, Both span records available Yes | Completion wait: 260 ms. The span sum of 340 ms includes overlap. |
Acceptance and limits
Models two simultaneous spans and a parent waiting on both. It does not infer every trace’s critical path.
Read the initial conditions and operational goal.
Change one condition and compare the decision.
Record the model boundary and outstanding checks.
Change a condition
Models two simultaneous spans and a parent waiting on both. It does not infer every trace’s critical path.
Completion wait: 150 ms. The span sum of 230 ms includes overlap.
{"known":"Completion wait: {ms} ms. The span sum of {sum} ms includes overlap.","unknown":"An interval is missing. Hold the decision until another source establishes it."}Check your understanding
Choose an option to see the result and explanation.
Check, then explain in your own words
- Read the initial conditions and operational goal.
- Change one condition and compare the decision.
- Record the model boundary and outstanding checks.
Check your understanding: Compare completion waits for two spans starting together.
Models two simultaneous spans and a parent waiting on both. It does not infer every trace’s critical path.
Record the model boundary and outstanding checks.
Sources and conditions checked
The official references used in this lesson are collected here with their scope, conditions and corresponding sections. Independent expert review and live AWS comparison have not been performed.
- AWS X-Ray conceptsChecked:
Scope and conditionsParallel spans do not add up to elapsed duration. Missing intervals leave causal evidence incomplete.
Used in this lessonWhat to predict Acceptance and limits