SQL Server DBA

Performance troubleshooting and query tuning

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.

This is 9 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples