Collections:
SELECT Test Summary on SQL Server 2016
What are performance differences of running the SELECT statement with different criteria and table storage options on SQL Server 2016?
✍: FYIcenter.com
Here is a summary of performance differences of running the SELECT statement with different criteria and table storage options on SQL Server 2016. Throughput is calculated as number of bytes retrieved per second in unit of MB/s.
@@version = Microsoft SQL Server 2016 - 13.0.5292.0 (X64) | Throughput MB/s Size Count | CURSOR BIGINT PRIMARY KEY MEMORY_OPTIMIZED ------------------------------------------------------------- 256 100 | 1.53 1.88 8.14 256 500 | 9.39 1.11 3.39 7.63 256 1000 | 7.40 0.54 2.37 15.26 256 5000 | 7.83 0.12 19.38 16.06 256 10000 | 8.25 0.18 19.85 14.11 512 10000 | 15.60 0.28 38.15 25.84 1024 10000 | 28.47 0.44 69.21 62.11 2048 10000 | 54.25 0.37 125.20 114.89 4096 10000 | 83.11 0.41 250.40 229.78 8192 10000 | 119.09 0.79 384.48 384.48 16384 10000 | 227.77 1.44 557.76 769.33 32768 10000 | 434.03 2.80 868.06 1250.00 32768 20000 | 425.17 1.33 889.05 1329.79 32768 50000 | 945.25 1284.95 32768 100000 | 888.79 1235.18 32768 500000 | 794.92 1101.13
As you can see:
? SQL Server Storage Tutorials
? SELECT with MEMORY_OPTIMIZED Table on SQL Server 2016
2019-05-15, 1173🔥, 0💬
Popular Posts:
How to find out my browser's identification information? To help you to see your browser identificat...
How to force JMeter to automatically flush test result to file immediately after each sampler is exe...
How to valid IPv6 addresses? In order to help your programming or testing tasks, FYIcenter.com has d...
How to generate MAC addresses? To help you to obtain some MAC addresses for testing purpose, FYIcent...
How to valid IPv6 addresses? In order to help your programming or testing tasks, FYIcenter.com has d...