(Republishing, or using this info in a commercial product/website, is prohibited without permission. All other uses are permitted. If in doubt, please ask.)
This latch is used to synchronize creation of new pages in an append-only storage unit in the version store, and must be acquired in EX mode.
(Books Online description: “Used to synchronize inserts in fast append-only storage units.”)
Questions/comments on this latch class? Click here to send Paul an email, especially if you have any information to add to this topic.
Added in SQL Server version:
Removed in SQL Server version:
Extended Events latch_class value:
The map_key value in sys.dm_xe_map_values is 21 in 2008 and 2008 R2, and 16 in 2012 and 2014 RTM. After 2014 RTM, you must check the DMV to get the latest value as some map_key values have changed in later builds.
If contention on this latch is excessive, you may need to disable snapshot isolation in one or more of the databases where it is enabled. It is also possible to see SLEEP_TASK waits if the buffer pool has a free page list stall (i.e. no available buffers) because of the volume of new pages being added to the version store.
Known occurrences in SQL Server (list number matches call stack list):
- Inserting a version into the version store while updating a column in a table row
And many more similar stacks when versioning is enabled in either of its forms.
Abbreviated call stacks (list number matches known occurrences list):