O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required