INFRASTRUCTURE LEARNINGINFRASTRUCTURE LEARNING
インフラ大全インフラ大全IT INFRASTRUCTURE / LEARNING
Infrastructure learning guide
Find a lesson or lab/

Esc to close · Search terms stay on your device

LEARNING日本語

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.

What you will learn

Compare completion waits for two spans starting together.

Prerequisite

The cases use fictional inputs.

Start the exercise →

What to predict

Parallel spans do not add up to elapsed duration. Missing intervals leave causal evidence incomplete.

From conditions to the decision
From conditions to the decision1: SQL Server span (ms) — Align conditions — Parallel read span (ms). 2: Parallel read span (ms) — Compare outcomes — Both span records available. 3: Both span records available — Verify the decision — Decision123SQL Server span (ms)Parallel read span(ms)Both span recordsavailableDecisionFrom conditions to the decision1: SQL Server span (ms) — Align conditions — Parallel read span (ms). 2: Parallel read span (ms) — Compare outcomes — Both span records available. 3: Both span records available — Verify the decision — Decision123SQL Server span(ms)Parallel readspan (ms)Both spanrecordsavailableDecision
  1. SQL Server span (ms) → Parallel read span (ms)Align conditions
  2. Parallel read span (ms) → Both span records availableCompare outcomes
  3. 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

Synthetic observations
CaseConditionsDecision
Trial 1SQL Server span (ms) 80, Parallel read span (ms) 150, Both span records available YesCompletion wait: 150 ms. The span sum of 230 ms includes overlap.
Trial 2SQL Server span (ms) 220, Parallel read span (ms) 150, Both span records available YesCompletion wait: 220 ms. The span sum of 370 ms includes overlap.
Trial 3SQL Server span (ms) 80, Parallel read span (ms) 150, Both span records available NoAn interval is missing. Hold the decision until another source establishes it.
Trial 4SQL Server span (ms) 80, Parallel read span (ms) 260, Both span records available YesCompletion 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.

Check your understanding

Choose an option to see the result and explanation.

What happens in trial 1?
Read the answer and reason

Answer: Completion wait: 150 ms. The span sum of 230 ms includes overlap. · 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.

What happens in trial 2?
Read the answer and reason

Answer: Completion wait: 220 ms. The span sum of 370 ms includes overlap. · 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.

What happens in trial 3?
Read the answer and reason

Answer: An interval is missing. Hold the decision until another source establishes it. · 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.

Check, then explain in your own words

  1. Read the initial conditions and operational goal.
  2. Change one condition and compare the decision.
  3. 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.