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

KB ​​ boundaries efficiently. ​​ Although ​​ SQL Server ​​ tries ​​ to use the log space as efficiently as possible, ​​ certain application patterns cause the log-block fill percentages to remain small. ​​ This creates 8?KB

Servers 40