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 actual execution plan

The actual execution plan is one of the most important features provided by SQL Server, as it tells us how the query has actually performed. We can find the bottleneck in query, if any, and find out the way to resolve it.

Getting ready

In the previous recipe, Working with estimated execution plan, we have already discussed about the importance of estimated execution plan, which shows how your query should be processed, with the way it should get executed.

Most of the time, your query runs exactly in the same way as it has been mentioned in estimated execution plan. But, what if you find that your execution plan is perfect and still your query execution seems slow? Well, in that case the actual execution plan comes ...

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