Sql Server 2016 Performance is terrible doing very simple inserts

Question

I am hoping someone can help me troubleshoot performance of sql server 2016.

Here are the 2 setups I have and I am comparing them

• Older dell lattitude laptop (i7 cpu, 16gb ram ssd) Windows 10 Sql Server 2014 Developer edition (x64)

• Newer dell (xeon cpu, 32gb ram, a lot faster ssd - 3x faster than my older laptop ssd in my tests) Windows 10 Sql Server 2016 Developer edition (x64)

Both versions of sql server were installed using all the default configuration. I really quickly noticed performance difference between the two

• restoring small database from backup takes about 5x longer on sql server 2016 (same database)
• inserting 11K data rows into an empty table without indexes (database is not in use other than app inserting data) sql server 2014 - 2 seconds sql server 2016 - 32 seconds

I have so far looked at the following

• error log does not have any errors.
• sys.dm_exec_query_stats does not give me any clues so far (it tells me that insert is slow, but since there are no scans, no indexes not sure what it can tell me)
• running sql server profiler does not show any problems
• doing some timers in code shows that the entire time is spent executed command object.

some details about the program

• dot.net 4.6.1 wpf app
• reads csv files and inserts data into a table
• the insert is done on a brackground thread using async
• timers clearly show that the problem is not with parsing csv file or anything else - just inserts
• SqlCommand object (as well as db connection) is being reused
• no explicit transactions specified
• when comparing 2 computers, the same exact program running doing the same exact thing (basically the only difference that I am looking at is hardware and different sql server version)

I am looking for some help to understand where to even start troubleshooting this. Here is what I am going to do next: install sql server 2016 on the older laptop and see if inserts are as fast as they were in sql server 2014 or will I see a significant slowdown

thanks

Answer 1

Thank for all the help. After some time troubleshooting and looking around I found this post: here I ran AS SSD Benchmark and right away noticed a huge problem with my harddrive (I guess not all SSD Benchmark software is created equal - the other one I tried showed me that my SSD rocks). I will now be focused on how to address this problem. Thank you all