Unexpected 10,000 Value Skips in SQL Server 2012 Primary Key Auto-Increment

Data and Databases
1

Issue Summary:

On a Windows Server 2012 running SQL Server 2012 and IIS for several Silverlight apps, one app auto-incremented primary keys skipping 10,000 values. How can this be fixed?

2

hey, i had simmilar issues; i found that disabling sql identity cahce fixed the problem. it seems caching cause auto incremnt jumps. maybe check your config to see if that helps.