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, 1051👍, 0💬
Popular Posts:
How to perform regular expression pattern match with multiple occurrences? To perform a regular expr...
How to call JMeter command in a Windows batch file? I want to create a single batch job to run JMete...
How to Open and Close Internet Explorer with UFT script? One way to open and close Internet Explorer...
How to Pass Windows Environment Variable to JMeter? I want to use Windows temporary folder environme...
How to convert a date and time to a standard format? Date and time can be displayed in a number of s...