Want to highlight a helpful answer? Upvote!

Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

SQL server performance: MAC Pro v. MacBook Pro

Morning Folks

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. Both are fully patched etc. and the Mac Pro is, in all other cases, blindingly faster than the laptop. i even compared disk write speeds by copying an 11gb text file, the laptop too twice as long as the desktop.


the thing thats not making any sense is the laptop is considerably faster running SQL Sever. 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. The speed difference of each step in a simple bulk insert, validate and aggregate process is proportional to the overall speed difference of the entire process.


Has anyone seen this behaviour before, or have any idea where to look?


Thanks


Mark

iPhone 4, iOS 5

Posted on Dec 18, 2017 2:20 AM

Reply
8 replies

There are no replies.

SQL server performance: MAC Pro v. MacBook Pro

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.