title: SQL Server 2012 slow
body: <p>I recently moved my .NET development from an older Core2Duo 2.93 GHz PC to a new Core i7-3820 3.6 GHz machine. No changes were made to the project code or database layout. Both machines use the same SQL Server 2012 Express with Advanced Services (not LocalDB).</p>
  
  <p>I observe a significant slowdown of INSERT INTO commands: what used to take 1-2 milliseconds per row on the old machine, now takes 8-9 milliseconds on the new one. The only fix I was able to find was to use multiple row inserts in one command, which seems to spread the overhead of the command over many rows. As in SQL Server 2008 R2, in SQL Server 2012 the limit for the number of rows in one such command is 1000:
  <a href="http://msdn.microsoft.com/en-us/library/dd776382.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/dd776382.aspx</a></p>
  
  <p>However, the multiple row workaround is not applicable to all scenarios; e.g. table adapter updates that go row by row and take a long time to complete.</p>
  
  <p>Has anyone experienced this problem? How would I go about resolving it?</p>