Specialized Performance Troubleshooting (Part 1: How to troubleshoot Forwarded Records)

This week I will discuss how to troubleshoot Forwarded Records issues.   What are Forwarded Records? If you have some time, you can read the full story at Paul Randal’s blog post: http://www.sqlskills.com/blogs/paul/forwarding-and-forwarded-records-and-the-back-pointer-size/ If not, I will tell you the short story: “They are a performance overhead that can occur when you insert rows into…

0