About the Talk
July 18, 2013 2:30 PM
Denver Microsoft Office - DTCDenver Microsoft Office - DTC
You just received a phone call from your boss telling you that a certain web page or report is timing out and your users are furious. You need to quickly diagnose what the problem is. Where do you turn to first? When a underperforming, hogging resources or timing out, the first thing you want to examine is the query execution plan. An execution provides a wealth of information that can help you quickly diagnose what is wrong. In this beginner level session you will learn what an execution plan is, how to find it, and how to interpret it to see what the query optimizer is doing and find the major pain points.