Remove 2048 Remove Efficiency Remove Operating System Remove Software
article thumbnail

SQL Server on Linux: Scatter/Gather == Vectored I/O

SQL Server According to Bob

Scatter/gather capabilities allow more efficient memory to disk transfers reducing redundant memory copies, sorting and other activities applications may require to gain improved I/O performance. On Linux the total number of buffers that can be read or written, in a single ABI request, is capped at 2048.

Servers 40
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

Subsystem / Path The ​​ I/O subsystem or path ​​ includes ​​ those ​​ components ​​ that are ​​ used to support an I/O operation. ​​ SQL Server ​​ copy-on-write actions are used to maintain snapshot databases in SQL Server 2005.

Servers 40