The clustered index is an identity key, so in theory it should be adding pages at the end. However, it still seems to cause locking issues.

The insert is a basic...