Silicon Valley Code Camp : October 6th and 7th, 2012
I am a Systems Performance Expert with specialization in Database and System Architecture. I have helped to deploy and maximize availability of large MES systems in several Semiconductor and Solar manufacturing fabs.
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.