Improving SQL Server Queries by Reading and Understanding Execution Plans
Before SQL Server executes a query, it generates an execution plan. Some plans are trivial, such as returning all the rows from a single table. However, when we go beyond the simplest of cases, SQL Server generates a "good enough" execution plan to accomplish the work. It'll use the indexes we've created, the statistics on those indexes, as well as how we’re manipulating the data based on the query to determine that execution plan. The hardware and the amount of data determine how fast the query returns.
If a query is performing poorly, there’s a lot within our control to improve performance. The key to doing so is understanding the execution plan.
In this webinar we'll cover how to use the tools SQL Server provides us to capture execution plans. We'll then walk through how to read an execution plan and how to use that information to write better queries. We'll discuss the impact of outdated statistics, improper indexing, and look at examples of T-SQL anti-patterns which cause our queries to run poorly. Finally, we’ll work through some remediation examples of those performance killers so you’ll have some tools with which to attack poorly performing queries in your own environment.
Thursday, October 03, 2019
1:00:00 PM EDT | 5:00:00 PM UTC
Brian Kelley is an author, columnist, Certified Information Systems Auditor (CISA), and former Microsoft Data Platform (SQL Server) MVP (2009-2016) focusing primarily on SQL Server and Windows security. Brian currently serves as a data architect as well as an independent infrastructure/security architect concentrating on Active Directory, SQL Server, and Windows Server. He has served in a myriad of other positions including senior database administrator, data warehouse architect, web developer, incident response team lead, and project manager. Brian has spoken at 24 Hours of PASS, IT/Dev Connections, SQLConnections, the Techno Security and Forensics Investigation Conference, the IT GRC Forum, SyntaxCon, and at various SQL Saturdays, Code Camps, and user groups.
Register for this webinar:
Copyright (c) 2006-2018 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.