SQL Server I/O 块大小参考表
操作 | IO块大小 |
---|---|
Transaction Log Writer | 512Bytes ~ 60KB |
Checkpoint / Lazywriter | 8KB ~ 1MB |
Read-Ahead Scans | 128KB ~ 512KB |
Bulk Loads | 256KB |
Backup / Restore | 1MB |
ColumnStore Read-Ahead | 8MB |
File Initialization | 8MB |
In-Memory OLTP CheckPoint | 1MB |