Do you struggle to understand why a query is running slowly? Or why it runs in less than a second most of the time and takes 10 minutes other times? Being able to review and understand query execution plans is essential to understanding bottlenecks in database performance. And while DBAs must understand execution plans, for proactive performance management, developers must also be able to review plans as queries and procedures get developed. In this session, you’ll learn how to gather and read execution plans, understand what query operators are and what actions they perform and understand the differences in plan types. Finally, you’ll learn how to improve your code and its performance by using the data revealed in these plans.
Speaker
Monica Rathbun
Microsoft MVP for Data Platform, a Microsoft Certified Solutions Expert and a VMWare vExpert
Monica lives in Virginia, is a Microsoft MVP for Data Platform, a Microsoft Certified Solutions Expert and a VMWare vExpert. She has nearly two decades of experience working with a wide variety of database platforms with a focus on SQL Server and the Microsoft Data Platform. She is a frequent speaker at IT industry conferences on topics including performance tuning and configuration management. She is the Leader of the Hampton Roads SQL Server User Group, on the Microsoft Azure Data Community Board and the Data Saturdays Board. She is passionate about SQL Server and the SQL Server community, doing anything she can to give back.
Monica can always be found on Twitter (@sqlespresso) handing out helpful tips. You can find Monica blogging at sqlespresso.com
Denny Cherry and Associates Consulting (https://www.dcac.com/)
Referenten