From the course: SQL Server 2016: Administer a Database Infrastructure
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Identify problematic execution plans - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Identify problematic execution plans
- [Instructor] Finding queries that are performing poorly has gotten easier with the introduction of the query store. However, it's still important to be able to review the actual execution plans for a query in order to see each step of the process and identify areas that could be made more efficient. Let's take a look at some execution plans for the Wide World Importers database. To view the execution plan, go ahead and toggle on a button on the tool bar, right here, called Include Actual Execution Plan. When I turn it on, it'll turn yellow. Now when I run a query, for instance SELECT * FROM Sales.Invoices that'll include the execution plan in the results. When the query is finished, you'll see this new tab called Execution plan. Let's go ahead and switch over to it. This will display each step the SQL server went through in order to find the results. It reads from right to left and bottom to top. Now these can get quite large. If you need to you can right click on it and choose zoom…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.