Uwe Ricken 05 January 2021 Uwe Ricken 05 January 2021 Heaps in SQL Server: Part 4 PFS contention 0 7 T-SQL Programming When inserting rows into a heap, SQL Server must sometimes update the PFS page which can PFS contention and affect performance. In this article, Uwe Ricken demonstrates how to measure PFS contention.… Read more