Ever open a huge query plan to track down a performance issue and find yourself overwhelmed by the number of objects on the screen? How do you figure out which part of the plan is causing the problem? What should you do about it? The vast majority of query plan troubles boil down to the same basic causes; solving them is simply a matter of knowing where to look. In this session you will learn how to open a plan and drill in to the most likely problem areas. Once there, a simple analysis of five key indicators will help you diagnose your performance problem faster than you thought possible. Say goodbye to guesswork and game playing. This session will teach you how easy it can be to apply a bit of logic to improve performance of your queries.
Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "SQL Server 2008 Internals" (Microsoft Press, 2009) and "Expert SQL Server 2005 Development" (Apress, 2007). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.