SQL Server on Linux: Scatter/Gather == Vectored I/O
SQL Server According to Bob
JANUARY 31, 2017
On Linux the total number of buffers that can be read or written, in a single ABI request, is capped at 2048. The buffers must be the operating system page size (4K.) There are a few locations (zero file, column store, …) in SQL Server which attempt to read or write more then 1024 database pages in a single request.
Let's personalize your content