3 ms·
Not always, this article describes the problem: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/resolve-pagelatch-ex-contention h
by rileymat2 3y ago
Not always, this article describes the problem:
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/resolve-pagelatch-ex-contention https://learn.microsoft.com/en-us/troubleshoot/sql/database-...
- hobs 3y agoExactly, with one big insert its better to have a sequential value, for many small ones its often better to not. As with all databases, measure before you cut.