SQL server 2014 slower on more powerful desktop than a laptop

Question

SQL server 2014 slower on more powerful desktop than a laptop

markdh.climb

SSC Veteran

Points: 212
More actions
December 15, 2017 at 5:25 pm

#334055

Hello....
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.
Thanks
Mark

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

markdh.climb SSC Veteran Points: 212 More actions · Answer 1

Also... both installs are updated to SP2. Running the same stored procedure on both and printing out timings shows each step as being slower by almost the same percentage as the complete process (bulk insert, validate, write to main table and produce aggregates.

I also tested hard disk speed, the servers ssd is about twice as fast as the laptop copying and 11gb text file.

Jeff Moden SSC Guru Points: 1004405 More actions · Answer 2

My recommendation would be to call Apple and ask them.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

goher2000 SSCertifiable Points: 5479 More actions · Answer 3

you might want to do sys.configurations comparison before you call Apple.

markdh.climb SSC Veteran Points: 212 More actions · Answer 4

Thanks... I wiped the system and started again, will take a look when it’s rebuilt.

MMartin1 One Orange Chip Points: 27799 More actions · Answer 5

I wonder if the SSDs are identical, as in reads/write (throughput? ) per second and such.

----------------------------------------------------