Remove 2048 Remove Database Remove Operating System Remove Software
article thumbnail

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

SQL Server According to Bob

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.

Servers 40
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? ​​ SQL Server ​​ copy-on-write actions are used to maintain snapshot databases in SQL Server 2005.

Servers 40