SQL server 2014 slower on more powerful desktop than a laptop

  • 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

  • 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.

  • 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)

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

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

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

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

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

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