SELECT with MEMORY_OPTIMIZED Table on SQL Server 2016

Q

What is the data read performance with the SELECT statement with a MEMORY_OPTIMIZED table on SQL Server 2016?

✍: FYIcenter.com

A

To see the data read performance with the SELECT statement with a MEMORY_OPTIMIZED table on SQL Server 2016, you can run the SQL script, fyi_select_in_memory.sql, presented in the last tutorial with different @Count and @Size.

The following table shows the summary of the test results. Some fields are removed to save space. additional fields are added with calculations on existing fields.

@@version = Microsoft SQL Server 2016 - 13.0.5292.0 (X64) 

 Size   Count  Duration        Bytes  Throughput MB/s 
  256     100         0        25600    
  256     500        16       128000             7.63
  256    1000        16       256000            15.26
  256    5000        76      1280000            16.06
  256   10000       173      2560000            14.11
  512   10000       186      5040000            25.84
 1024   10000       156     10160000            62.11
 2048   10000       170     20480000           114.89
 4096   10000       170     40960000           229.78
 8192   10000       203     81840000           384.48
16384   10000       203    163760000           769.33
32768   10000       250    327680000         1,250.00
32768   20000       470    655360000         1,329.79
32768   50000      1216   1638400000         1,284.95
32768  100000      2530   3276800000         1,235.18
32768  500000     14190  16384000000         1,101.13

As you can see the peak throughput of reading data, 1,329.79 MB/s reached at @Size=32768 and @Count=20000.

? SELECT Test Summary on SQL Server 2016

? Test Script for SELECT with MEMORY_OPTIMIZED

? I/O Tests on SELECT Statements

?? SQL Server Storage Tutorials

2019-04-17, 1413🔥, 0💬

Introduction to Selenium
Where to find tutorials on Introduction to Selenium? Here is a list of tutorials to answer many frequently asked questions compiled by FYIcenter.com team on Introduction to Selenium. What Is Selenium ⇒ What Is Selenium ⇐ Selenium Tutorials ⇑⇑ Selenium Tutorials 2019-09-14, ∼1973🔥, 1💬

What Is Selenium
What Is Selenium? Selenium is a set of open-source software tools each with a different approach to supporting test automation. The entire suite of tools results in a rich set of testing functions specifically geared to the needs of testing of web applications of all types. These operations are high... 2019-05-28, ∼1955🔥, 0💬

WebDriver and WebDriver Servers
Where to find tutorials on WebDriver and WebDriver Servers for different browsers? Here is a list of tutorials to answer many frequently asked questions compiled by FYIcenter.com team on WebDriver and WebDriver Servers for different browsers. What Is WebDriver Google ChromeDriver WebDriver Server St... 2019-06-15, ∼1876🔥, 0💬

Test Script for SELECT with MEMORY_OPTIMIZED
Where can I get a SQL script to do I/O performance test with SELECT statement on a MEMORY_OPTIMIZED table? Here is a SQL script to do I/O performance test with SELECT statement using BIGINT PRIMARY KEY on a MEMORY_OPTIMIZED table. -- fyi_select_in_memory.sql -- Copyright (c) FYIcenter.com -- DECLARE... 2019-04-23, ∼1618🔥, 0💬

Test Script for SELECT with PRIMARY KEY
Where can I get a SQL script to do I/O performance test with SELECT statement using BIGINT PRIMARY KEY as the search criteria? Here is a SQL script to do I/O performance test with SELECT statement using BIGINT PRIMARY KEY as the search criteria. It uses the fn_virtualfilestats() function table to ca... 2019-05-18, ∼1491🔥, 0💬

SELECT with MEMORY_OPTIMIZED Table on SQL Server 2016
What is the data read performance with the SELECT statement with a MEMORY_OPTIMIZED table on SQL Server 2016? To see the data read performance with the SELECT statement with a MEMORY_OPTIMIZED table on SQL Server 2016, you can run the SQL script, fyi_select_in_memory.sql, presented in the last tutor... 2019-04-17, ∼1414🔥, 0💬

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? 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 calc... 2019-05-15, ∼1400🔥, 0💬

SELECT with PRIMARY KEY on SQL Server 2016
What is the data read performance with the SELECT statement with a PRIMARY KEY field on SQL Server 2016? To see the data read performance with the SELECT statement with a PRIMARY KEY field on SQL Server 2016, you can run the SQL script, fyi_select_in_memory.sql, presented in the last tutorial with d... 2019-04-24, ∼1363🔥, 0💬

SELECT with PRIMARY KEY on Azure SQL Database
What is the data read performance with the SELECT statement using PRIMARY KEY as the search criteria on Azure SQL Database? To see the data read performance with the SELECT statement using PRIMARY KEY as the search criteria on Azure SQL Database, you can run the SQL script, fyi_select_primary_key.sq... 2019-04-21, ∼1342🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.