Describe your systematic approach to identifying and optimizing slow queries in a production database. How do you use execution plans and query statistics to prioritize which queries to optimize first?

Sample answer preview

Identifying and optimizing slow queries is one of the most impactful activities a DBA performs. The key is having a systematic approach that prioritizes based on total impact rather than just individual query duration. My first step is gathering query performance data.