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

Working with estimated execution plan

Estimated execution plan is the result of query optimizer, it is generated even before the query execution. Hence, it might have some or more changes when compared with the actual execution plan, but in most cases the actual and estimated execution plan remain almost the same.

Getting ready

As a DBA, many times you might come across a situation where you come to the office in the morning, somebody comes to you complaining that one of the page is taking a long time to display data which was working just fine and fast some days back. What would you do in the first step? How do you determine where the problem is?

This is the time where the estimated execution plan comes into picture. You take the query or stored ...

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