This 15-minute conference talk from SREcon25 Americas explores a methodology for annotating and tracing SQL queries from client-side to database server-side. Learn how Xiaotong Jiang from Databricks demonstrates an effective system for aggregating database server usage across various client-side dimensions such as RPC and tenants. Discover how this approach has proven valuable in addressing client-initiated incidents and how the query tracing system can be leveraged to analyze query behavior, particularly to support large-scale data migration operations. The presentation offers practical insights for SREs and database administrators looking to improve observability and troubleshooting capabilities in OLTP database environments.
Overview
Syllabus
SREcon25 Americas - OLTP SQL Database Query Tracing and Linting
Taught by
USENIX