Continuing my series of articles on latches, this time I’m going to discuss the APPEND_ONLY_STORAGE_INSERT_POINT latch and show how it can be a major bottleneck for heavy update workloads where either form of snapshot isolation is being used.
I strongly recommend you read the initial post in the series before this one, so you have all the general background knowledge about latches.
As always, read the whole thing.