All 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 2889 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


Unit of data in Buffer Pool

August 8, 2017 Internals 1042 Views

/_include/blog-images/article-images/buffer-pool-unit-of-data.jpg

SQL Server updates 8KB of data when you update one single bit of data.

Read More


Why does SQL Server consume so much memory?

August 8, 2017 Internals 1476 Views

/_include/blog-images/article-images/ram-memory2.jpg

There is a reason why SQL Server consumes so much memory; It does not leak memory, and there is a reason behind that.

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 483 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 2320 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 699 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


Next Page