1:45 PM Saturday Room: 1401
Many systems performance issues are caused by suboptimal SQL queries or poorly designed schema. It is often quoted that fixing a SQL performance issue in production is more than 30 times costly than fixing it in development phase. So, it is imperative that developers have the skills to analyze SQL performance, find root causes of slow performance and optimize the SQL before any of their code is released to production. This session goes through the steps to quickly analyze and identify root cause of suboptimal SQL performance.