What is SQL Server identity allocation and identity cache behavior?

Identity values are preallocated in cache to improve insert performance but can cause gaps.

SQL Server caches identity values in memory to reduce allocation overhead during inserts. If the server restarts or cache is lost, unused values are discarded, leading to gaps. This behavior is expected and cannot guarantee continuous sequences. It improves performance by avoiding disk contention for every insert.