Monotonically increasing clustered index keys can cause LATCH contention

In this post, I shall explain why monotonically increasing or decreasing clustered index key columns can create hot spots for your index pages with the help of an example. A hot spot is simply an active portion of the table which is accessed more frequently than the rest of the table. A general thumb-rule (No…