top of page
Writer's pictureMadeira Team

How to Fix Latch Problems when Working with Ascending Keys in SQL Server

Traditionally, we want our Clustered Index to have the following attributes:

  1. Narrow: So that our clustered index and the non-clustered indexes that point to it will be as slim as possible

  2. Static: So that we don’t generate fragmentation in the clustered index and we don’t have to update the non-clustered indexes

  3. Ever-increasing: So that we don’t generate a lot of page splits and fragmentation when we insert rows into the index

For the vast majority of systems, this will be a very good choice. The problem is that for a certain scale, this isn’t good enough. That’s because each insert has to acquire a latch on the last page of the index, and that hurts insert performance.

Watch the video to see how latch problems like this can be solved:


0 comments

Recent Posts

See All

Comments


STAY IN TOUCH

Get New posts delivered straight to your inbox

Thank you for subscribing!

bottom of page