SharePoint 2016 Data Access Performance test

Four years ago, I did a simple data access performance test on SharePoint 2010 ( http://fangdahai.blogspot.com.au/2012/09/sharepoint-2010-data-access-performance.html ). Today, same test was done on SharePoint 2016.

Test environment is similar. Host machine is Ivy bridge core i7 + Samsung 840 Pro SSD + 32GB RAM, and the SharePoint 2016 virtual server is with 4 CPU cores and 12GB RAM. Most of the SP services (including Search service) are disabled. SQL Server is 2016 DEV CU2 with maximum 4GB RAM on the same virtual machine. During test, only 6GB RAM is consumed on SP server.

The test result is a bit disappointing. The only improvement is "bulk update", and others are much slower.

Plan to do a similar test on SharePoint Online in the near future, through PowerShell + CSOM. Hopefully it's more interesting.

To make it easier for comparison, SharePoint 2010 test result is copied as below.

SharePoint 2010.

Action	Single, 1 thread	Bulk, 1 thread	Single, 4 thread	Bulk, 4 thread
Insert	85	140	215	245
Update	75	300	450	1150
Delete	40	70	115	110
Retrieve	1000	N/A	2000	N/A

Here is SharePoint 2016.

Action	Single, 1 thread	Bulk, 1 thread	Single, 4 thread	Bulk, 4 thread
Insert	43	59	169	85
Update	43	1774	227	3557
Delete	25	61	57	147
Retrieve	2133	N/A	2327	N/A

Single, 1 thread

Bulk, 1 thread

Single, 4 thread

Bulk, 4 thread

[update, 2016-10-19]

Windows Form program:

https://github.com/Eric-Fang/PerformanceTest