Forwarded Records and Performance – SQL in Sixty Seconds #155

Earlier I wrote a blog post on Forwarded Records and Performance and lots of people liked the blog post. Here is you can read the blog post SQL SERVER – What is Forwarded Records and How to Fix Them?

Here is the video which I have built on that topic.

Forwarded Records

Forwarded Records are the data row in a heap that has moved from the original page to the new page. A heap table is a table without a clustered index. When a user updates a column with a larger size of data, it is possible that a particular field now can’t fit on the same data page leaving a forwarded record of that data.

When SQL Server scans the heap to read the necessary data, they often encounter forwarding record pointers which usually exist on the different page leading SQL Server to read more pages than required while dealing with the heap. This is the reason, often performance of the heap has been very bad.

Here are my few recent videos and I would like to know what is your feedback about them. You can subscribe to my youtube channel here.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Menu
Exit mobile version