Is there any issue with Identity Insert. Do other concurrent operations without it goes fine or do it create slowness or deadlocks?

I want to to keep moving data with old primary keys and want to keep inserting data with new keys as well.

thanks in advance

CodePudding user response：

Identity insert work independently with concurrent operations since it is not global and is session based, so other query sessions will keep working and generating same output weather its on in 1 session or off

More this is explained here

What is the scope of SET IDENTITY_INSERT xyz ON?

It also not created any slowness and deadlocks