Chapter 6. Tuning with Execution Plans
In this chapter we will cover:
- Understanding Hash, Merge, and Nested Loop Join strategies
- Finding Table/Index Scans in execution plan and fixing them
- Introducing Key Lookups, finding them in execution plans, and resolving them
Introduction
Performance tuning needs concentration in the following areas:
- Deciding the performance baseline of your environment
- Monitoring current performance and finding bottleneck
- Resolving the bottleneck to get good performance
An Estimated Execution Plan is a kind of blue-print that defines how a query should actually perform, whereas an Actual Execution Plan is like a mirror that tells you what happened while executing the query. By looking at this fact you can find the bottleneck and ...
Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
