Execution Plans blogs

/_include/blog-images/article-images/page2.png

Pages in Buffer Pool fall in to two different types.......

Read More


SQL Server Pages and Extents

August 8, 2017 Execution Plans 2220 Views

/_include/blog-images/article-images/page2.png

SQL Server reads and writes data in bunches of 8KB pages. Space allocation is based on batches of 8 pages, which is called Extents.

Read More


/_include/blog-images/article-images/runtime-constants.png

Some SQL functions are constants. They get evaluated once at the beginning of the query and remain the same all over the execution time. One good example is the GETDATE() function.

Read More


/_include/blog-images/article-images/execplans-128.png

Estimated Exection Plan is not 100% clear. There are some queries that are hidden in that.

Read More


/_include/blog-images/article-images/execplans-128.png

Some queries do not appear in Actual Execution Plans; and are totally hidden. Sometimes, this weird behaviour makes query optimization difficult.

Read More


Actual vs Estimated Execution Plans

July 30, 2017 Execution Plans 447 Views

/_include/blog-images/article-images/actual-vs-estimated-exec-plans-128.png

There are two types of Execution Plans; Estimated and Actual Execution Plans. The biggest difference between the two types of execution plans is the time SQL Server generates the plan.

Read More


Blocking vs Non Blocking operators

July 25, 2017 Execution Plans 1914 Views

/_include/blog-images/article-images/execplans-128.png

Some operators stop the execution while they are executing while some others pass out pieces of data as they are execution. Some operators behave either blocking or non blocking depending on the situation.

Read More


How to read Execution Plans

July 25, 2017 Execution Plans 636 Views

/_include/blog-images/article-images/reading-execution-plan.png

Reading Execution Plans reveals a lot of details about the way SQL Server executed the query; and is the first step to optimizing query performance.

Read More


/_include/blog-images/article-images/what-is-execution-plan-cartoon.jpeg

In order to read and understand an Execution Plan, it is important to know what an Execution Plan is made of.

Read More


/_include/blog-images/article-images/what-is-execution-plan-cartoon.jpeg

Arrows in an execution plan imply the flow of data from one operator to another. However, it is not the only thing they imply...

Read More


Next Page