this is driving me nuts. I have a macbook pro and a mac pro both running windows 10. The macbook pro has 4 2.8ghz cores, 16gb ram and a 1tb ssd, the mac pro has 8 3ghz cores, 64gb ram and 1tb ssd. Both are running on boot camp and ive gone through all the performance related settings and made sure they are the same. Neither is connected to a network and neither is running anti-virus etc. I.e. they are both completely isolated.
the thing thats not making any sense is the laptop is considerably faster. For example, a 2.5 million record bulk insert in sql server 2014 takes 3 seconds on the laptop and 6 on the desktop. Ive checked the sql settings on both and they are identical at database and server level, both use simple recovery mode etc.
Has anyone seen this behaviour before, or have any idea where to look. Ive been on this all day pretty much and got nowhere.