Does auto increment on Primary Key prevent concurent inserts?
If I change this column to a long with auto-increment enabled. Will this become a concurrent insert bottleneck?


The answer is NO because the step when SQL Server gets next identity value is outside of transaction. This is why when you perform ROLLBACK identity does not decrease and you can have gaps.

Please see answer to similar question here