Question
Query latency versus query duration: how should each guide initial triage?
Answer
Latency is end-to-end user-observed elapsed time, including application and network work. Duration is server-side request execution time. Start with latency for impact; compare duration to localize whether SQL Server is the dominant contributor.