Sample Header Ad - 728x90

Identity Column in Concurrency, Multithreading, Parallel Processing

5 votes
2 answers
4196 views
Our company would like to understand the effects: - If we have single table with Primary Key Identity column, int primary key IDENTITY(1,1), - and the Application is conducting multi-threading parallel processing, trying to conducts 1000s of simultaneous inserts on one table. Would the identity primary key column fail, with a primary key violation in any way, for example: processors are trying to input the same identity number? Or was SQL designed to be successful even in multithreading parallel insert? Note: IDENTITY_INSERT is OFF
Asked by user129291
Sep 9, 2017, 05:58 AM
Last activity: Jun 20, 2018, 12:42 AM